Grab the fill handle (+) in the bottom right corner of the cell and pull it downwards to populate all the other cells in the specified range.The second argument, $B$2:B2, is simply the range of cells you want to count. The first argument, 3, instructs Excel to count the numbers in the range. Select the first cell to which you’d like to assign a number and then enter the following formula:.This situation can confuse and complicate data analysis.Įven if you’ve filtered your data, you can still add row numbering to your sheet. When presenting data, filtering enables you to share just what your audience needs without throwing too much information all at once. Only the unfiltered rows will be shown onscreen at any given time. It will enable you to select certain parts of your worksheet and have Excel show only those cells.įor example, if you have lots of repetitive data, you can easily filter out all of those rows and leave just what’s you need.

The filter is a function that allows you to sift (or slice) your data based on criteria. How to Auto Number Filtered Rows in Excel Without a doubt, this is one task that can be frustrating. Now imagine assigning numbers to each of these rows manually. At this point, enter the step value (“1” by default) and then enter the stop value in the spaces provided.Įt voila! All the cells in the selected column will now have unique and sequential serial numbers for easy identification. Did you know your Excel sheet can have up to 1,048,576 rows That's right.In the dialog box, select ‘Columns’ from the ‘Series in’ section.This should open a floating dialog box in the middle of your sheet. Click on “Fill” and then select “Series” from the dropdown menu.Click on “Home” at the top of your sheet.Enter the first value, say 10, in the first cell.Select the first cell to which you’d like to assign a number.Here’s how to autofill row numbers in Excel using the fill series function: In this situation, the fill series feature will autofill 10 rows in the selected column, starting with “1” in the first cell, “2” in the second cell, through “10” in the last cell. For example, let’s say your start, step, and stop values are 1, 1, and 10, respectively.

Excel how many rows in the sheet