How to Number the Rows in Excel 2007

By Joseph Horst

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.

Fill Column

Step 1

Select the first cell in spreadsheet.

Step 2

Type the starting value in that cell.

Step 3

Type another value in the next cell to start sequence.

Step 4

Select cells with values that you've typed inside.

Step 5

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

ROW Function

Step 1

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 2

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 3

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

Tips & Warnings

  • In Microsoft Excel 2007, a "fill handle" is the small black square in the lower right corner of a selected cell. Moving the cursor onto the square changes it to a black cross.