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 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 11085 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 34618 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 43319 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 43627 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 55152 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 9437 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 47862 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 32199 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 26161 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 17841 2020-04-12 11:37:21
-
- How to randomly generate decimals within a range in excel
- The method for excel to randomly generate decimals within a range is: 1. First select the cell range; 2. Then enter the formula [=randbetween]; 3. Then set the upper and lower limits of the random number; 4. Finally press the [ctrl+enter] key That’s it.
- excel 72151 2020-04-11 15:04:42
-
- How to delete duplicates in excel
- The method to delete duplicates in Excel is: 1. First select the cells containing duplicates; 2. Then switch to the [Data] tab, find and click the [Delete Duplicates] option; 3. Finally, click [In the pop-up window] OK].
- excel 4029 2020-04-11 14:32:39
-
- How to set the first row of the table to always display in excel
- The method to set the first row of the table to always be displayed in Excel is: 1. First open the Excel table and select a cell; 2. Then switch to the [View] menu bar and select the [Freeze Panes] option; 3. Finally, in the pop-up drop-down menu Select the [Freeze First Row] option.
- excel 21458 2020-04-11 14:18:45
-
- How to use rounding function in excel
- The method of using the rounding function in Excel is: 1. First select the cell and click [fx]; 2. Then search and select the ROUND function and click [OK]; 3. Finally set the function parameters and click [OK].
- excel 11297 2020-04-11 10:15:32
-
- How to show hidden columns in excel
- The method to display hidden columns in Excel is: 1. First open the Excel table; 2. Then select the hidden column, right-click with the mouse, and select the [Unhide] option in the pop-up page.
- excel 16023 2020-04-10 13:32:54
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
