Excel Problem - Can anyone help, please?
Thread Starter
Joined: May 2007
Posts: 1,415
Likes: 2
From: Europe
Excel Problem - Can anyone help, please?
Dear all,
Since the days of Lotus 123 and Supercalc, I have been creating columns or rows of consecutive numbers by putting in the first number, and then in the next cell a formula to add 1 to the first cell value, eg "A1+1". I then copy that formula down the column or across the row to get 1, 2, 3, 4..........etc
There might be a more sophisticated way, but it works(ed) for me.
As from yesterday, the formula is copying OK, ie A1+1, A2+1, A3+1, and so on.
But the value shown in each cell is the value of the first one, ie 1, 1, 1....and so on.
I have tried all the variations of pasting formulas, values etc but none puts this right.
It's Excel 2007, with Vista. This is now happening on all Excel files in that computer (from a sample of 5 or 6)..
Moving any of the files to another computer (Excel 2007, XP) does not change things.
It's driving me crazy; any ideas would be much appreciated!
Since the days of Lotus 123 and Supercalc, I have been creating columns or rows of consecutive numbers by putting in the first number, and then in the next cell a formula to add 1 to the first cell value, eg "A1+1". I then copy that formula down the column or across the row to get 1, 2, 3, 4..........etc
There might be a more sophisticated way, but it works(ed) for me.
As from yesterday, the formula is copying OK, ie A1+1, A2+1, A3+1, and so on.
But the value shown in each cell is the value of the first one, ie 1, 1, 1....and so on.
I have tried all the variations of pasting formulas, values etc but none puts this right.
It's Excel 2007, with Vista. This is now happening on all Excel files in that computer (from a sample of 5 or 6)..
Moving any of the files to another computer (Excel 2007, XP) does not change things.
It's driving me crazy; any ideas would be much appreciated!
Joined: Jun 2009
Posts: 1,344
Likes: 80
From: Bedford, UK
odd
Presume you mean '=A1+1' etc, ie equals sign in there. Does the 'fill' command work (from memory rhs of home toole bar. Pick series with increment as 1.
Other than that , no '$' signs in the formula ? Cells formatted as 'general' or number with appropriate significant places ?
Other than that , no '$' signs in the formula ? Cells formatted as 'general' or number with appropriate significant places ?
Thread Starter
Joined: May 2007
Posts: 1,415
Likes: 2
From: Europe
Many thanks Mr O..
I should have mentioned the = sign for the formula; yes, it was there.
I have never used the Fill command, being hardly aware of its existence.
However......
SUCCESS!
Fill > Series, select columns or rows, step value and final value, and it works a treat. Much better and easier than my old formula method from Lotus 123* days in 1983, or even its predecesor, if there was one.
Many thanks for the invaluable steer.
But I'm still puzzled about why copying the +1 formula into multiple cells has started to work so oddly, and it's going to niggle until I can see why.
*Or was it something like "Visicalc" then, before Supercalc? Memory grows dim.
I should have mentioned the = sign for the formula; yes, it was there.
I have never used the Fill command, being hardly aware of its existence.
However......
SUCCESS!
Fill > Series, select columns or rows, step value and final value, and it works a treat. Much better and easier than my old formula method from Lotus 123* days in 1983, or even its predecesor, if there was one.
Many thanks for the invaluable steer.
But I'm still puzzled about why copying the +1 formula into multiple cells has started to work so oddly, and it's going to niggle until I can see why.
*Or was it something like "Visicalc" then, before Supercalc? Memory grows dim.
Joined: Aug 2005
Posts: 3
Likes: 0
From: E.Wash State
Easier method:
Enter the number, x in A1
Enter the next in the series, x+1 in A2
Now mouse-Select the range A1 to A2, then click on the little dohicky in the lower right of the selected range and drag it down as far as you want.
All the cells in the newly expanded range will be filled as you wished.
Voila! ....?
Enter the number, x in A1
Enter the next in the series, x+1 in A2
Now mouse-Select the range A1 to A2, then click on the little dohicky in the lower right of the selected range and drag it down as far as you want.
All the cells in the newly expanded range will be filled as you wished.
Voila! ....?
