My 14yr old can't help

[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.

 

[Don Guillett]

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

 

[Guest]

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

 

[joeu2004]

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?

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.

 

[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.

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.

 

[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

 

[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.

Thanks all,
Now I can show that smart little 14 yr old something!

Mike