Adding 1 to a number for 30 columns.

  • Thread starter Thread starter Jason263
  • Start date Start date
J

Jason263

Thank you for everyone who assisted mewith my last question.

What I would like to do at this time, is, Place a number in one cell
and have it add 1 to the number for 30 columns without typing in eac
cell, "=a2+1", for 30 columns.

What is the code I need to do this?

Thank you to all who respond.

Jason
 
if you wish to add 1 to a1, then add 1 to b1, etc., use this

in cell b1, type

=a1+1

then copy that cell across the remaining columns...
the results will be your original number in a1, that number plus 1 in b2,
that number plus 2 in c1, etc.

that's if you mean COLUMNS...going horizontally across the worksheet

if you really mean ROWS...goig vertically down the worksheet

put your number in the first cell, put the equation

=a1+1 in cell a2

then copy that equation from a3 down to a30...

as always with microsoft, there are others ways, too, but this should work!
 
Type a number in A1, select the row by clicking on the row number, and
click on Edit | Fill | Series | Step value: 1 | Stop value: 30 | OK.
 
Jason, put 1 in a unused cell copy it, select the numbers you want to add
one to, right click and paste special, add, this should add one to all the
selected cells.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
Enter 1 in any cell that you are not using
Copy this cell (Ctrl C)
Highlight all your columns
Go to : Edit/Paste Special/Add
Click OK
 
I have a problem with the "Fill/Series..." solution: This would onl
work if the value in the first cell is "1". If the beginning numbe
is, say, 25, using the "Stop Value" of 30 will only fill 5 cells (26
27, 28, 29, and 30) then stop. The Stop Value needs to be the actua
number you want to stop at, not the number of cells to fill.

Am I correct on this
 
Start at 25. Select 10 cells.

Edit>Fill>Series Step Value = 1 Stop Value = 30

You will get 25(original),26,27,28,29,30 and that's it.

So....You are correct.

Gord Dibben Excel MVP
 
Back
Top