Often I have to add consecutive ID numbers to data after-the-fact.


1. I add the column  to the left of my data.

2. I enter the value "1" (or my starting number) in A2 where my
records/line items begin

3. I tab the column to the right (cell B2)

4. I use Ctrl+Down Arrow

5. If the data is contiguous (no empty cells) then you will reach the
bottom of the range  in Column B

6. Use Left Arrow to move Column A

7. Now use Ctrl+Shift+Up Arrow to select  all the way to the first
filled cell in Column A

8. Remember it has the value "1"

9. Select fill  from the Edit menu

10. Choose Series ...

11. In the dialog box everything should be set to create 1 to n for the
range you selected. So I won't go into all that.
12. Click OK and you are done.

Tip: Sometimes I will put "x" as a bumper at the bottom or right end of my
range in empty columns and rows. When I want to fill the range with a
formula or other information. All I have to do is CTRL+Shift+Down Arrow (or
right arrow) and I have the selection exactly as I want it.