How do you auto number in Excel?

Answer 1

There are different ways. You could type in the numbers, which would be a slow way. You could use the fill facility. You could use a function, such a ROW(). It will always give you the number of the current row. If you wanted to start at number 1, but were not in row 1, then you could just adjust the value that row gives. So if you were in row 5 and wanted to get 1, then that is 4 less than the current row, so you would subtract 4 from row like this:

=ROW()-4

Then that could be copied down for more values.