How to Auto Number in Excel 2007

Functions
1. Click the first cell in the row or column you want to number.
2. Type '=TEXT(ROW(A1), '000')' to number the rows beginning with '1' and with the format 001, 002, etc. Replace 'A1' with a different cell reference to begin at a different number; use 'A2' to begin with 002, for example. In this formula, the cell reference returns the row number of the cell. You can use any cell reference in the formula, not just the reference for the cell the formula is in. Replace '000' with '$0.00' for dollar format, '0%' for percent format or use your own format.Only type '=ROW(A1)' if you want numbers in standard format -- 1, 2 and so on.
3. Press 'Enter' on your keyboard and Excel will calculate the formula. Select the same cell again and hover your pointer over the bottom right corner of the cell until a black cross appears. Click and drag down to cover as many cells as you want to number.
Fill Handle
4. Click to select the cell where you want to begin numbering and type your first number.
5. Select the next cell in the row or column you are numbering and type the second number in your series. For standard numbering, type '1' in the first cell and '2' in the second. Use '2' and '4' to number by twos, '10' and '20' to number by tens, and so forth.
6. Click the first cell and hold the left mouse button down. Drag down or right to the second cell so both are selected at once.
7. Hover the pointer over the bottom right corner of the second cell until you see a black cross. Click and drag down to number rows or to the right to number columns. Let go of the mouse button when you reach the cell where you want the numbering to end.