Thursday, August 11, 2011

How to Number the Rows in Excel 2007


Fill Column
1. Select the first cell in spreadsheet.
2. Type the starting value in that cell.
3. Type another value in the next cell to start sequence.
4. Select cells with values that you've typed inside.
5. Drag 'fill handle' to include number of cells that you want in your sequence.
ROW Function
6. Type '=ROW(A1)' into the first cell of the range you want to sequence. This will give you the number 1 in that cell.
7. Type specific number after '=ROW(A1)' to start numbering at a certain point. For example, typing '=ROW(A1),'2010-000' will create a starting number of 2010-001.
8. Drag 'fill handle' to include number of cells that you want in your sequence.

Blogger news