How to Number the Rows in Excel 2007

When creating spreadsheets in Microsoft Excel 2007, certain situations may come up in which you want to number the rows in the spreadsheet sequentially. Microsoft Excel 2007 also allows you to dictate how you want the sequence to follow. For example, each row could start with only even or odd numbers. Though Microsoft Excel 2007 does not have a simple button to click to do this like other Microsoft Office products do, you can complete this task using a different method.

...
Numbering rows in Excel 2007 can be done very simply.

Fill Column

Step

Select the first cell in spreadsheet.

Step

Type the starting value in that cell.

Step

Type another value in the next cell to start sequence.

Step

Select cells with values that you’ve typed inside.

Step

Drag “fill handle” to include number of cells that you want in your sequence.

ROW Function

Step

Type “=ROW(A1)” into the first cell of the range you want to sequence. This will give you the number 1 in that cell.

Step

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.

Step

Drag “fill handle” to include number of cells that you want in your sequence.