Excel Excel 2007 - Pasting a simple formula issue

H

hoejoo

Joined
Oct 28, 2009
Messages
2
Reaction score
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.
 
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:
 
My laptop must not have taken its Prozac yesterday, because this is not an issue today...puzzling. Thanks!
 
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.....
 
Back
Top