current location：Home > Technical Articles > Topics > excel
- Direction：
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Daily Programming WeChat Applet Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify：
-
- Why can't the table be edited?
- The table cannot be edited because the protection mode is set. The solution: 1. Open a table on the desktop; 2. Find the "Review" tool on the table and click it; 3. Find and click "Unprotect Worksheet" Editing can be resumed.
- excel 42952 2023-03-28 13:54:43
-
- What should I do if the form cannot be printed outside the dotted line?
- Solution to the problem that the table cannot be printed outside the dotted line: 1. Open the excel file and click "Print" on the opened page; 2. Find "No Zoom" on the preview page and select to adjust to one page; 3. Select the printer to print. Documentation is enough.
- excel 9873 2023-03-28 11:38:12
-
- Practical Excel skills sharing: three commonly used methods for checking data
- Presumably those of you who often use Excel will encounter the problem of checking data. How do you usually do it? VLOOKUP? COUNTIF? However, the most practical verification method is not them? Who else? Hurry up and take a look with the editor!
- excel 3959 2023-03-27 19:59:54
-
- Excel chart learning: highlighting the maximum and minimum values in the line chart
- The line chart is a relatively simple and widely used chart. But as the saying goes, the simpler something is, the more attention it pays to details. Only when these details are in place can the boss be truly satisfied! Today, the editor will teach you how to grasp these two details - the maximum and minimum values, so that your line chart will impress your boss.
- excel 4052 2023-03-22 17:57:53
-
- Excel function learning: due date calculation, several application examples of EDATE() function
- Hello everyone! Usually we always need to calculate various expiration dates, such as contract expiration date, employee regularization date, product validity period, etc. The common practice is to use the DATE function to calculate, but the calculation formula of the DATE function is too cumbersome. Is there a simpler formula? Of course there is! Just use EDATE~
- excel 4221 2023-03-21 18:33:03
-
- Excel function learning: Drag Queen TEXT()!
- Among Excel's functions, there is a function called the magician, which is TEXT. However, today, we prefer to call it a drag queen! why? Please read below!
- excel 1810 2023-03-20 17:55:45
-
- How to center cells without merging them
- The method to center cells without merging is: 1. Enter a title in a cell; 2. Select the cell where the title should be centered; 3. Right-click and select "Format Cells"; 4. Under "Alignment", Find "Horizontal Alignment", then select "Center Across Columns" and click "OK".
- excel 20588 2023-03-20 16:09:17
-
- How to use DATEDIF() in Excel function learning
- This article will introduce you to the DATEDIF function! The DATEDIF function can not only be used to calculate age, length of service, length of service salary, and project cycle, but can also be used to make birthday countdown reminders, project completion date countdown reminders, and so on. With it, you will never miss those important days again, whether it's a loved one's birthday, a project completion day, or your son or daughter's graduation day.
- excel 24127 2023-03-17 20:04:38
-
- How to swap the contents of two cells
- How to swap the contents of two cells: 1. Open the Excel file and click on one of the cells whose contents need to be swapped; 2. Move the mouse to the edge of the cell, and the cursor changes to a four-way arrow; 3. Press and hold Hold down the Shift key, hold down the left mouse button and drag the cell to another cell to swap the contents of the two horizontal cells.
- excel 14010 2023-03-17 14:08:35
-
- Practical Excel skills sharing: 3 ways to quickly replace part of numbers with asterisks!
- In order to protect customer privacy, we usually change customer phone numbers to * numbers. How is this achieved? Here are 3 ways to hide local phone numbers with asterisks, take a look!
- excel 5679 2023-03-16 19:51:37
-
- Excel function learning: the simplest conditional summation function DSUM()
- It is called the simplest conditional summation function! Because it has been anonymous in the world for many years, it is not known to others. Although it is not as famous as the SUMIFS function, its unique multi-condition summation method still makes it invincible. The formula of SUMIFS is like a long train, and its formula is like a short taxi. Now it's time to reveal its mystery, it is - the DSUM function!
- excel 2028 2023-03-15 20:01:56
-
- Practical Excel skills sharing: quickly convert text data in batches!
- Are you still using column splitting to batch convert text data? No wonder you always work overtime! The following article will share with you two methods of quickly converting text data in batches. I hope it will be helpful to you!
- excel 8260 2023-03-14 19:24:04
-
- Excel function learning: How to use the search function INDEX()
- This article takes you through the INDEX function! INDEX is also a member of the search family. Due to its powerful coordinate positioning function, sometimes VLOOKUP has to step aside!
- excel 10244 2023-03-13 19:48:00
-
- How to use the MATCH() function in Excel function learning
- Today we’re going to talk about another family – Find the Family! Speaking of finding families, I believe the first thing that comes to mind is the VLOOKUP function. This eldest brother has been working hard in the battlefield for many years and has already become famous! I believe that friends who have been exposed to Excel have heard of it to some extent. However, what we are going to talk about today is its capable little brother - the MATCH function!
- excel 13695 2023-03-10 19:47:00
-
- Why does the ID number change when I enter it in Excel?
- Reason: The ID number is a numeric string. If you input it directly, Excel will consider it to be a numerical data. When the number of digits in the data exceeds 11, Excel in the regular format will record it as scientific notation. , when the number exceeds 15 digits, Excel will only refine it to 15 digits, and the values in the following digits will all be 0. Solution: 1. Click the cell where the ID number is located; 2. Right-click the cell and select "Format Cells"; 3. Click the "Number" tab, select "Text" from the category list, and click "Sure".
- excel 47747 2023-03-10 11:14:20
Recommended Articles
Tool Recommendations
jQuery enterprise message form contact code
jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29
HTML5 MP3 music box playback effects
HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.
Player special effects
2024-02-29
HTML5 cool particle animation navigation menu special effects
HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29
jQuery visual form drag and drop editing code
jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29
Organic fruit and vegetable supplier web template Bootstrap5
An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03
Bootstrap3 multifunctional data information background management responsive web page template-Novus
Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02
Real estate resource service platform web page template Bootstrap5
Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02
Simple resume information web template Bootstrap4
Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02
Cute summer elements vector material (EPS PNG)
This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09
Four red 2023 graduation badges vector material (AI EPS PNG)
This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29
Singing bird and cart filled with flowers design spring banner vector material (AI EPS)
This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29
Golden graduation cap vector material (EPS PNG)
This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27
Home Decor Cleaning and Repair Service Company Website Template
Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09
Fresh color personal resume guide page template
Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29
Designer Creative Job Resume Web Template
Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28
Modern engineering construction company website template
The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28
