How to automatically number after filtering in excel

Is the serial number automatically sorted after excel filtering? The method is very simple, come and learn it.

Method for automatic numbering after excel filtering

The steps for automatic numbering after EXCEL filtering are:

1. First open one of the tables in excel, and then hold down ctrl to continue the serial number.

2. After filtering some names, you will find that the serial numbers are not consecutive.

Recommended learning: Excel basic tutorial

3. Next, click on the right side to create a new one Serial number column, enter =subtotal in this cell, and then select 3.

4. Then enter the complete formula =subtotal(3, B$2:B2) in the cell.

5. After selecting the serial number, then press and hold the ctrl enter shortcut key on the keyboard to refresh the serial number, and you can set it to automatic numbering.

For more excel related tutorials, please pay attention to PHP Chinese website!

The above is the detailed content of How to automatically number after filtering in excel. For more information, please follow other related articles on the PHP Chinese website!