My 14yr old can't help

A

amdx

Hi all,
My smart 14yr old can't help me!
I want to put data into column a, 100,000 thru 2,000,000.
A1 is 100,000, a2 is 110,000, a3 is 120,000, etc. all the way
to 2,000,000. ie, column a increases by 10,000 as it goes down.
Can this be done by a calculation? I don't want to type in all these
numbers.

Thanks, Mike.
 
D

Don Guillett

Get a 13 year old
100000
110000
highlight both>goto lower right corner of a2>grab the cross>drag down
 
R

Ron Coderre

Try this:

Put 100000 in the first cell and select that cell

From the Excel main menu:
<edit><fill><series>
Series in: Columns
Step value: 10000
Stop value: 2000000
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
J

joeu2004

amdx said:
I want to put data into column a, 100,000 thru 2,000,000.
A1 is 100,000, a2 is 110,000, a3 is 120,000, etc. all the way
to 2,000,000. ie, column a increases by 10,000 as it goes down.
Can this be done by a calculation?
Click to expand...

Besides the two mechanical methods of replication that respondents have
suggested, yes, there is an obvious "calculation" to accomplish the
same thing. Put 100000 into A1, then in A2 put:

=A1+10000

Right-click Copy A2, click (select) A3, shift-click A191 (which selects
all of A3:A191), then right-click Paste. The relative reference will
be changed automagically to A2+10000 etc.

There is some advantage to using a formula. If you want to change the
starting number, you need only change the first cell. A disadvantage
is: if you want to change just one cell in the middle of the series,
it will affect all cells below it unless you also change the cell
immediately below it.
 
J

joeu2004

PS ....
Put 100000 into A1, then in A2 put:
=A1+10000
Right-click Copy A2, click (select) A3, shift-click A191 (which selects
all of A3:A191), then right-click Paste. The relative reference will
be changed automagically to A2+10000 etc.
Click to expand...

And in case you are unable to determine that A191 is the last cell in
your series, you can use the drag-lower-right-corner procedure,
mentioned by another respondent, to copy A2 downward as far as you
need. Again, Excel will automagically update the relative reference in
each cell.
 
D

Don Guillett

In fact you don't need to drag>just double click the cross and it will auto
copy down to the number of rows in the adjacent column to the left
 
A

amdx

amdx said:
Hi all,
My smart 14yr old can't help me!
I want to put data into column a, 100,000 thru 2,000,000.
A1 is 100,000, a2 is 110,000, a3 is 120,000, etc. all the way
to 2,000,000. ie, column a increases by 10,000 as it goes down.
Can this be done by a calculation? I don't want to type in all these
numbers.

Thanks, Mike.
Click to expand...
Thanks all,
Now I can show that smart little 14 yr old something!

Mike
 
Top