« What is the difference between a workbook and a worksheet? Why would you want to use separate worksheets when
AlGeBra!!!!???!!!!!!? »

How do you set up an excel worksheet to add columns?

I used to know years ago, but haven’t had to use excel in quite a while. I’m having to create an excel worksheet to keep track of basic inventory. The first column lists the card number of a set with 140 cards, for example. I am wanting to set up the spreadsheet to where it’ll automatically number the rows in that column with the correct card number. Please, help?
adding like 1 plus 1 from one row to the next without having to manually type in the card # in each row in the same column

Sure you can simply drag a formula down.

Try this for example, I think it is what you mean, and you can then use it on yours.

Type 1 in A1
Type this formula in A2 "=A1+1"

Then select A2, and look for the small square in the bottom right corner of the selected cell. Click on this and drag downwards for as many rows as you need.

(you could just put 1 in A1, 2 in A2, select both then drag this down, that would work as well)

This entry was posted on Friday, October 2nd, 2009 at 5:44 pm and is filed under worksheet. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “How do you set up an excel worksheet to add columns?”

  1. XLMan Says:
    October 2nd, 2009 at 11:15 pm

    I need more info.
    Adding new columns to excel sheet like in Insert > Rows needs VBA
    Auto numbering column is another issue

    contact me

    Read my profile, I am XLMan
    References :

  2. land_bus Says:
    October 2nd, 2009 at 11:42 pm

    I’m not sure what you mean but i have an idea. In the first row type 1, second row type 2, third row type 3. Then select the three cells. Once selected click on the bottom left corner of the box (there is a little black box there) and drag the mouse down and a yellow box appears with a number in it, drag until that number equals 140. Sorry if thats not what you want.
    References :

  3. Xenu.net Says:
    October 3rd, 2009 at 12:17 am

    Sure you can simply drag a formula down.

    Try this for example, I think it is what you mean, and you can then use it on yours.

    Type 1 in A1
    Type this formula in A2 "=A1+1"

    Then select A2, and look for the small square in the bottom right corner of the selected cell. Click on this and drag downwards for as many rows as you need.

    (you could just put 1 in A1, 2 in A2, select both then drag this down, that would work as well)
    References :

Leave a Reply