Suppose you have a dataset as shown below: 1] Using Fill Handleįill handle identifies a pattern from a few filled cells and can easily be used to quickly fill the entire column. You can choose any one of the methods that work based on your dataset. Or, you might have a dataset that has a few blank rows in it, and you only want to number the rows that are filled.
The best way to number the rows in Excel would depend on the kind of data set that you have.įor example, you may have a continuous data set that starts from row 1, or a dataset that start from a different row.
