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.
0 kommentar(er)
