2012-10-03

Excel: row numbering

It took me more than 5 minutes to actually find the right link for my problem to number rows automatically with some correction on where to start.

=ROW()-9

If placed in A10, this will give you 1.

Here's the original article, where I found it from:

http://agsci.psu.edu/it/news/2010/11/automatically-number-rows-in-excel

No comments: