Excel consecutive numbering

Hi, I know that you can do this but I have forgotten how.  I want to take a number like 100 and put it in A1, followed by 101 in A2, 102 in A3, 103 in A4, etc.  Can someone please remind me how to do this?
Thanks.
camtzAsked:
Who is Participating?
 
andrewssd3Connect With a Mentor Commented:
One way is to type 100 in A1, then 101 in A2, the select both and drag the handle in the bottom right down.  This will autofill as far as you want.
0
 
andrewssd3Commented:
You can also use the fill series Dialog for more complex scenarios.  In 2007 and 2010 this is on the Home tab, Editing, Fill button.  I'm afraid I've forgotten what menu it's on in 2003 and earlier - was it Tools...Autofill, or maybe Edit...Autofill
0
 
AgeOfEmpiresCommented:
The prior response is an excellent response.  Only thing that I would add is if you are dealing with a very large table (1000's+ of rows), dragging can be a pain sometimes.  If that is the nature of your data, you can choose the first empty column just to the right of your data and type in 100 in row 1 (or whatever the first row is), type 101 in row 2, highlight both cells, and then double-click to thick/small black box in the bottom corner of the selection.  Excel will auto-increment your numbering sequence all the way down until it finds the first empty cell in the adjacent column to the left.  Depending on the nature of your data, this can be faster than dragging.  Once auto-incremented all the way down, you should do an "end-down" to goto to the last populated cell in the new column just to make sure Excel went as far as you think it should have (just in case there was a blank cell on a row in the column to the left that you were unaware of)
0
All Courses

From novice to tech pro — start learning today.