Excel consecutive numbering

Posted on 2011-10-22
Last Modified: 2012-05-12
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?
Question by:camtz
    LVL 17

    Accepted Solution

    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.
    LVL 17

    Expert Comment

    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
    LVL 4

    Expert Comment

    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)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now