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 automatically fill in the current time in Excel?
- How to automatically fill in the current time in Excel: first right-click the first cell and click [Format Cells]; then click [Date] on the left and select the date type; then enter the formula "=IF(B2 ="","",IF(C2="",NOW(),C2))"; Finally, set the table to iterative calculation.
- excel 21627 2020-06-13 13:38:14
-
- How to remove duplicates and keep unique ones in Excel?
- The only way to remove duplicates in Excel is to keep it: first click [Data] in the top navigation of Excel; then select the data to remove duplicate values; then find [Delete Duplicate Values] in the menu bar and click it; finally select the column to be operated on , and click OK.
- excel 7465 2020-06-13 13:14:20
-
- What should I do if all the last few digits of the ID card number in the Excel table become 0?
- The solution to the problem that all the last few digits of the ID number in the Excel table have become 0 is: 1. Select the cell where the ID number needs to be entered; 2. Right-click the cell and select the [Format Cell] option; 3. Select the [Text] option under the [Number] column and click [OK].
- excel 17663 2020-06-13 13:06:04
-
- excel serial number autofill
- The method for automatic filling of serial numbers in Excel is: 1. Select the cell that needs to be filled with the starting serial number; 2. Enter the starting serial number "1"; 3. Move the mouse to the lower right corner of the cell. When the mouse turns into a cross, Press and hold the Ctrl key on the keyboard; 4. Finally, drag the mouse downward.
- excel 9963 2020-06-13 11:10:25
-
- How to make drop-down menu in excel table
- The method to create a drop-down menu in an excel table is: 1. Select the cell and switch to the [Data] tab; 2. Select the [Data Validity] option in the pop-up secondary menu; 3. Set the validity conditions to allow the sequence to be provided Use the drop-down arrow to set the source to the drop-down item that needs to be provided.
- excel 7816 2020-06-13 09:55:04
-
- What should I do if the file format and extension of the excel table do not match?
- The solution to the mismatch between the file format and extension of the excel table is: 1. Press the [win+r] shortcut key to open the run; 2. Enter regedit and click [OK] to open the registry editor; 3. In the ShellNew file Clip the new string value; 4. Modify the numerical data to the Excel installation directory.
- excel 32750 2020-06-13 09:31:41
-
- How to make slash in Excel table?
- There are two methods: 1. Open Excel and click on the cell, click "Shape" in "Insert" on the menu bar, select a straight line, use the mouse to draw a straight line starting from the upper left corner of the cell, and a slash effect will appear. ; 2. Select the cell, right-click and click "Border" in Format Cells, select "Slash" in the lower right corner, and click OK.
- excel 11160 2020-06-12 18:01:28
-
- How to set Excel table header to be included on every page?
- How to set the header of an Excel table to be included on every page: First, click [Page Layout--Print Title] in the menu bar of the Excel table; Then in the "Page Setup" dialog box, click the Mark button behind the "Top Title Row"; then click the "OK" button; and finally click the "Print Preview" button.
- excel 36062 2020-06-12 17:02:16
-
- What should I do if the screen cannot be filled when converting excel to pdf?
- The solution to the problem that the excel-to-pdf conversion cannot fill the screen: First, set the paper size to A4 in "Page Layout"; then click "Save As" to bring up the save document interface; then select [PDF(*. pdf)]; finally save it and open it automatically.
- excel 13341 2020-06-12 16:47:35
-
- How to calculate working years in excel?
- How to calculate working years in excel: first enter the original data in the excel table; then enter the formula [=(TODAY()-B2)/365] in the cell of the working years column; then press Enter to get the result; finally Just use the fill handle to fill the rest of the cells.
- excel 58109 2020-06-12 16:35:50
-
- How to connect two cells in excel?
- How to connect two cells in Excel: first enter [=] in the blank cell and click on the first cell to be merged together; then click on the [shift,7,&] symbol and click on the cell to be merged together the second cell; then click on the cell to be merged in the same way; and finally press enter.
- excel 21674 2020-06-12 16:12:58
-
- How to group the same content together in excel sheets?
- Method: 1. Open a table and select the data you want to sort, click "Sort and Filter" in "Start" and select "Custom Sort"; 2. Click "Main Keywords" in the "Sort" pop-up window and select Name the columns with the same content, and use the default options for "Sort By" and "Order"; 3. Click OK, and the same content will be arranged together.
- excel 79427 2020-06-12 16:03:23
-
- How to use formula from previous row in Excel table?
- Method: 1. Open the excel worksheet, select the cell in the previous row, and set the relevant formula; 2. Move the mouse to the lower right corner of the cell until the mouse turns into a thick solid cross; 3. Pull down to fill in and continue to use it. The formula on the previous line calculates the result.
- excel 24813 2020-06-12 15:20:19
-
- How to do column sorting in excel?
- Operation steps: 1. Open the excel table, select the data, and click "Column" in "Data" above; 2. In the text column interface, select the delimiter symbol and click Next; 3. Check other delimiters in the delimiter symbol. , enter "-" on the right side and continue to the next step; 4. Select the default option in the text column pop-up window without modification, and click Finish.
- excel 9656 2020-06-12 14:38:09
-
- How to set up custom filtering in Excel?
- Method: 1. Open the Excel document you want to filter, select any cell, and click the "Filter" option in the "Data" tab; 2. Click the drop-down button next to the data, click "Number Filter" in the pop-up window, and select " Custom filter"; 3. Enter the values of "greater than or equal to" and "less than or equal to" in the pop-up window, and click OK.
- excel 17004 2020-06-12 14:19: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
