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:
-
- What is the shortcut key to undo the previous step in excel?
- The shortcut key to undo the previous step in excel is [ctrl+z]. How to use it: first open an excel file; then click on a cell; then enter a character in the cell; finally find ctrl and z on the keyboard. key and press [ctrl+z] to successfully undo the operation performed in the previous step.
- excel 78294 2020-09-29 11:19:43
-
- How to sum a column of data in excel
- How to sum a column of data in excel: first open an excel table data; then select a column of data; finally click the [Automatic Sum] option in the toolbar options with the mouse.
- excel 118013 2022-01-12 14:59:46
-
- How to convert date into pure number in excel
- How to turn dates into pure numbers in Excel: First open the EXCEL table that needs to be operated, and enter "=text(" in the formula edit box; then click on the cell and enter the formula "yyyymmdd"; finally press Enter to complete the formula" =text(A1,"yyyymmdd")" can be entered.
- excel 91618 2020-09-11 11:11:14
-
- How to stagger vertical lines in excel table
- How to stagger vertical lines in an Excel table: 1. Open the Excel table, select two cells, and click Merge and Center in the toolbar; 2. Click the straight line in the inserted shape and hold down the shift key to draw a vertical line.
- excel 18183 2020-09-11 11:04:56
-
- How to check excel version information
- How to check the excel version information: first open any worksheet; then click the [File] option in the top navigation bar; then click the [Account] option; finally click the [About Excel] button in the account information to view excel Version Information.
- excel 63622 2020-09-14 15:55:36
-
- How to delete duplicate data in excel so that only one remains
- How to delete duplicate data in Excel so that only one remains: first select the cell where the duplicate data is located; then click the [Data] tab at the top; and finally click the [Delete Duplicates] option in the [Data Tools] group.
- excel 94010 2020-09-14 16:16:08
-
- How to add page numbers in excel
- How to add page numbers in Excel: First open the page setup window; then select the location to insert the page number under the [Header and Footer] tab; then select to insert the page number in the middle; and finally click the [OK] button.
- excel 20963 2020-09-15 14:17:35
-
- Method for batch recovery of wps ID number 000
- Method for batch recovery of wps ID number 000: first use wps software to open the file that needs to be edited; then find the location of the problematic ID number, and click to select this selection; then right-click the mouse and find [ Set cell format] function; finally select the text function below the number corresponding to the number and click OK.
- excel 23678 2020-09-09 14:55:51
-
- How to automatically add numbers in table drop-down
- How to automatically add numbers in the table drop-down: first enter a string of long numbers in the table; then select a column of blank cells, right-click the mouse, and click "Format Cells" to enter; then select the value in the cell, and Change the number of decimal places to zero; finally select the fill sequence in the fill style.
- excel 126941 2022-01-12 15:24:57
-
- How to use random function rand in excel
- How to use the random function rand in excel: first enter the formula [=INT(100*RAND())+1] in cell B1; then press Enter to get a random number; finally pull down the cell to get a set Cells within 100.
- excel 31996 2020-09-02 09:42:05
-
- What should I do if there is a section in the table that has no grid lines?
- The solution to the problem that there is no grid line in the table: first select the area where the grid lines are not displayed, right-click the "Format Cells" option; then click "Pattern"; then click "Border", "Outer Border", "Internal" option; finally click "OK".
- excel 29704 2020-09-04 13:35:15
-
- How to automatically mark rising or falling arrows in Excel while calculating function comparisons
- How to automatically mark rising or falling arrows while calculating function comparisons in Excel: First select the cell and click Conditional Formatting; then click the icon and select the [Manage Rules] option under the Conditional Formatting column; then enter the edit rule page. Edit; just sum the data at the end.
- excel 22867 2020-09-05 17:15:09
-
- What to do if the excel table content is too long
- The solution to the problem that the content of the Excel table is too long: 1. In the cell alignment setting, select "Automatically wrap"; 2. Widen the cell column width to display all; 3. In the cell alignment setting, select " "Reduce font"; 4. Merge cells to display.
- excel 73349 2022-01-12 15:21:13
-
- What are the filling methods in excel?
- The filling methods in Excel are: 1. Select the cells that need to be filled, and click the [Fill] icon in the font column of the [Start] tab; 2. Right-click the selected cell and select [From the options that open] Set cell format] and click the [Fill] option.
- excel 25232 2020-09-05 11:00:45
-
- In order to achieve multi-field classification and summarization, what tools does Excel provide?
- In order to achieve multi-field classification and summary, the tool provided by Excel is a pivot table. Pivot tables are powerful tools for calculating, summarizing, and analyzing data, helping you see comparisons, patterns, and trends in your data.
- excel 25459 2020-08-31 14:42:09