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：
-
- How to extract age from ID number
- How to extract the age from the ID number: First, put the person's ID number in the same column of the spreadsheet and create the corresponding header; then use Excel functions to generate data; then enter the company "=YEAR(TODAY) in the cell ())-MID(B2,7,4)"; finally press the "Enter" key to generate the age.
- excel 40760 2020-04-17 09:53:40
-
- Why is the automatic summation 0?
- The automatic sum is 0 because the table data contains hidden strings and cannot be summed. The solution is: first open the Excel file; then use the replace function to test the characters; then find the location of the hidden characters; then select the cell area and start batch conversion of the data; just sum it up at the end.
- excel 25500 2020-04-17 09:10:11
-
- What should I do if excel cannot copy and paste to another sheet?
- The reason why Excel cannot be copied and pasted to another sheet is because the two Excels are different processes. The solution is: first close the file to be copied; then open the file through the "Open" command of the Excel file; finally click the accepted "Enable editing" of the protected view file can solve the problem of not being able to copy and paste.
- excel 25529 2020-04-16 16:44:49
-
- How to sort many names in Excel according to the number of strokes in the last name?
- How to set sorting by the number of strokes of the surname in Excel: select the name column to be sorted, then click "Data" on the menu bar, select "Sort", click "Options" in the pop-up window, the "Sort Options" window will pop up, select "Sort strokes", click OK.
- excel 6384 2020-04-16 13:36:57
-
- How to split a row into multiple rows in excel
- The method to split a row into multiple rows in Excel is: 1. First select the cells that need to be split into multiple rows; 2. Then switch to the [Home] tab and find the [Fill] option; 3. Finally, click [Fill] , then select [Align Both Ends].
- excel 20148 2020-04-16 13:34:12
-
- How to add a slash in the middle of the table
- How to add a slash in the middle of the table: 1. Select Insert-Shape-Line, and then use the mouse to draw a slash. 2. Right-click the selected cell, select "Format Cells", select "Slash" in the border options, and click OK.
- excel 11380 2020-04-16 11:53:22
-
- Excel prompts that the version is too low, how to upgrade
- The method to upgrade the excel version is: 1. First open excel; 2. Then click the [Help] menu bar and select the [Detect Update] option in the pop-up drop-down menu; 3. Finally, wait for the version detection to be completed and click [Update]. .
- excel 34754 2020-04-16 11:18:52
-
- How to use mobile phone to create form documents
- How to use a mobile phone to create table documents: first open the WPS software on the mobile phone and click the "New" button; then click the "Table" icon in the interface; then use the tools in the menu to edit the table content; finally click on the floppy disk-like icon in the upper left corner icon and select the location to save the file.
- excel 43538 2020-04-15 10:37:39
-
- What should I do if 'The list source must be a demarcated data list' appears?
- The solution to the problem that "the list source must be a demarcated data list" appears: first sort out the data sources to be referenced; then set the "name" and "first-level drop-down menu"; then use the "indirect" function to set the data Validity; finally enter the real data according to actual needs.
- excel 43785 2020-04-15 09:18:11
-
- What is the function formula to find duplicate values?
- The function formula for finding duplicate values is [=IF(COUNTIF($A:$A,A1)>1,"Duplicate","Not Duplicate")]. The method of using it is: first open the excel table where duplicate values need to be found; Then position the mouse in cell C1; then enter the function formula in the edit bar; and finally press the Enter key on the keyboard.
- excel 55302 2020-04-15 09:12:53
-
- How to filter spreadsheets
- How to operate spreadsheet filtering: first select the data, find the data in the tool menu, and select "Filter"; then view functions such as ascending order, descending order, and color sorting; then select the data text that needs statistics; and finally in the pop-up dialog box , enter the keywords you want to exclude, and select and click "Equal" to perform the filtering operation.
- excel 9612 2020-04-14 11:18:55
-
- What should I do if the mouse turns into a cross in Excel?
- The solution to the problem that the mouse turns into a cross in Excel is: 1. First open the Excel worksheet that needs to be modified; 2. Then switch to the [View] menu bar, find the [Reading Mode] option, and click this option.
- excel 48188 2020-04-13 11:23:35
-
- What should I do if the ID card shows E+17 after copying and pasting it into exls?
- The solution to the problem that "E+17" is displayed after copying and pasting the ID card into exls: first right-click on the cell; then select "Format Cells" from the right-click menu; then in the open Format Cells window, click "Number" tab; finally, select "Text" in the category list in the Number tab and click "OK".
- excel 32357 2020-04-13 10:42:38
-
- How to extract accurate age from ID number
- How to extract the precise age from the ID number: First create an Excel with the ID number and put the ID number in column A; then enter the formula "=DATEDIF(TEXT(MID(A1,7,8),"#- 00-00"),TODAY(),"Y")"; put "√" at the end to get the age.
- excel 26276 2020-04-13 09:50:27
-
- How to convert date to year month day format
- How to convert dates into adult month and day format: First open the excel table; then right-click the mouse and find "Format Cells"; then find "Numbers" in the pop-up dialog box, and find "Numbers" under the "Numbers" tab Date"; finally click "OK" to convert the date into year-month-day format.
- excel 17965 2020-04-12 11:37:21
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
