Excel 2007 - Pasting a simple formula issue

Excel Discussion in 'Microsoft Office' started by hoejoo, Oct 28, 2009.

  1. hoejoo

    hoejoo

    Joined:
    Oct 28, 2009
    Likes Received:
    0
    I'm trying to use column A as a 'sequence' number (1, 2, 3, 4, 5, ...) in a spreadsheet, so I enter '1' in cell A1 and enter the simple formula =A1+1 in cell A2 (which correctly returns the number 2). But, when I copy the simple formula in cell A2 and paste it into cell A3, the value in the cell is 2 even tho the formula shows as =A2+1. This works just fine in Excel 97 and 2003, so what am I doing wrong?

    Thx for any advice you can give.
     
    hoejoo, Oct 28, 2009
    #1
    1. Advertisements

  2. hoejoo

    Ian Administrator

    Joined:
    Feb 23, 2002
    Likes Received:
    929
    I've just tested this out on Excel 2007 and it works fine on my PC. I'm at a total loss as to why it would add 1+2 and make 2? :confused:
     
    Ian, Oct 29, 2009
    #2
    1. Advertisements

  3. hoejoo

    hoejoo

    Joined:
    Oct 28, 2009
    Likes Received:
    0
    My laptop must not have taken its Prozac yesterday, because this is not an issue today...puzzling. Thanks!
     
    hoejoo, Oct 29, 2009
    #3
  4. hoejoo

    Chuck D

    Joined:
    Nov 23, 2007
    Likes Received:
    2
    Alternative is to enter "1" is cell A1 and then select all the way down the column(as far as you wish) and then Edit / Fill / Series.... enter step value 1 and click ok.....
     
    Chuck D, Jan 3, 2010
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.