How to set up automatic numbering sorting in Excel How to set up automatic numbering sorting in Excel

How to set up automatic number sorting in Excel? In the process of editing Excel tables, we will use sorting, but many of them use manual methods, which are inefficient. You can set up automatic number sorting. In today's software tutorial, let's take a look at the specific steps. I hope you can Provide help to users. How to set up automatic number sorting in Excel 1. Take Microsoft Excel table as an example. First, open a blank Excel table, click on a blank box, and enter the number 1.

2. Then hold down the Ctrl key and pull the [Fill key] in the lower right corner of the cell where the number 1 is located to select other blank cells.

3. Then the Excel table will automatically fill in the tables in order based on the numbers in the first table, as shown in the figure below. fenye4. If you want to modify and automatically sort the original data, you can modify it according to this method. First modify the cell data, then hold down Ctrl and pull down to replace the selected incorrect data.

5. If we do not hold down the Ctrl key when pulling down, all the selected cell data will be replaced with the data of the first cell. You can click the [ that appears in the lower right corner AutoFill] button and select [Fill Sequence].

The above is the detailed content of How to set up automatic numbering sorting in Excel How to set up automatic numbering sorting in Excel. For more information, please follow other related articles on the PHP Chinese website!