current location:Home > Technical Articles > Topics > excel

  • What is the shortcut key to undo the previous step in excel?
    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
    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 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 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 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
    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
    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
    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 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 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?
    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 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
    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?
    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 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

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.

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