Auto fill numerically with literal "Step" before the number.

Posted on 2011-10-27
Last Modified: 2012-08-13
I have an Excel spreadsheet that I want to do a fill with the literal "Step" before the consecutive number in the column.  In other words it would look like:

Step 1
Step 2
Step 3
Step 4
Step 5
Step 6

I tried to do a "Fill" but Excel would not let me put in the literal "Step" before the number.

When I select the cells I would like them to auto fill like:
Step 1
Step 2
Step 3
Step 4
Step 5
Step 6

Thanks in advance.
Question by:donnie91910
    LVL 27

    Accepted Solution

    To manually do this:
    1) Type "Step 1" in the first cell.
    2) Type "Step 2" in the second cell.
    3) Highlight both cells.
    4) Click and drag downward on the range handle (the very small black square on the bottom right of the highlighted range).

    The cells will automatically fill and increment the numerical portion.
     range fill example
    LVL 33

    Assisted Solution

    Do you mean when you enter Step 1 in the first row and drag down the 1 isn't incremenenting?

    Or are you trying to use code?

    If it's code this should work.
        With Range("A1")
            .Value = "Step 1"
            .AutoFill Destination:=.Resize(6), Type:=xlFillDefault
        End With

    Open in new window

    LVL 51

    Assisted Solution

    by:Bill Prew
    This works fine in Excel 2010, using the "autofill" drag capability, what version are you using?

    Or are you trying to type in a formula of some sort?

    I just entered "Step 1" in A1, "Step 2" in A2, and then selected both cells, and used the small block in the lower right of the selection to drag downward to fill with the series.


    LVL 80

    Assisted Solution

    If you want to use the Fill command in the Editing group of the Home menu (Excel 2007 and 2010), then:
    1) Select the fill range, making sure that the top cell says Step 1
    2) Click the Fill menu item
    3) Choose Series from the resulting popup
    4) Choose the option for Autofill

    LVL 22

    Assisted Solution

    Obviously, you know how to Fill. Do you know how to format the cells to have the word (followed by a space) "Step " in the cell?

    Hit the Format dropdown, choose More number formats, Custom and type this in:
    "Step "#

    Hi, Brad!
    LVL 92

    Expert Comment

    by:Patrick Matthews
    Annie!  Great to see you here again!


    Author Closing Comment

    All worked. Thanks

    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

    Join & Write a Comment

    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvieā€¦
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculā€¦
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    754 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

    19 Experts available now in Live!

    Get 1:1 Help Now