Excel Excel 2007 - Pasting a simple formula issue

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.
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
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:
 
Joined
Oct 28, 2009
Messages
2
Reaction score
0
My laptop must not have taken its Prozac yesterday, because this is not an issue today...puzzling. Thanks!
 
Joined
Nov 23, 2007
Messages
28
Reaction score
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.....
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel VBA 1
Excel Copy COUNTIF while retaining reference 7
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
excel formula 1
Excel Conditional Formatting 1
Excel =SUM(A1=A1+B1) 0
Excel Import Comments 3

Top