Sequential numbering of filtered tables in Excel

Sequential numbering of filtered tables in Excel

Sequential numbers are assigned to the filtered tables.

Sequential numbering of filtered tables in Excel

Filter by “female.”

Sequential numbering of filtered tables in Excel

Sequential numbers are assigned to this table. Enter “1” in the first cell after the filter.

Sequential numbering of filtered tables in Excel

Select the rows to be sequentially numbered.

Sequential numbering of filtered tables in Excel

In this state, click on “Home” – “Search and Select” – “Select Conditions and Jump” to open “Selection Options”.

Click on “Visible Cells.

Sequential numbering of filtered tables in Excel

The filter will be canceled once. Only the female cells will be selected.

Sequential numbering of filtered tables in Excel

Click on “Home” – “Fill” – “Create Continuous Data”. Set the settings as follows

Sequential numbering of filtered tables in Excel

Now only the filtered rows will be sequentially numbered.

Sequential numbering of filtered tables in Excel

コメント

タイトルとURLをコピーしました