Copying a formula down 20K rows

[lizhere]

I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea how or
where to type those directions (macros???I hope not).
Thanks

 

[Bernard Liengme]

If there are entries immediately to the left (or the right) of the column
where the formulas are to do, then all you need do is double click the fill
handle
best wishes

 

[RagDyeR]

One way:

With your formula already entered in A1,
Right click in A1 and choose "Copy",
Click in A2,
Click in the Name Box (left of formula bar)
Type in
a20000
Hold down <Shift>
Hit <Enter>
Release <Shift>
Hit <Enter> again,
You're done!
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying to
20K rows than grabbing the fill handle and moving down that long.
I tried reviewing some of the tips in "programing" but I have no idea how or
where to type those directions (macros???I hope not).
Thanks

 

[Gord Dibben]

If no adjacent columns of data use this method.

In the namebox type A1:A20000 and ENTER

Then CTRL + D to copy down.


Gord Dibben MS Excel MVP

 

[lizhere]

I couldn't get the double click to work, but this one did! Thanks so much

 

[lizhere]

use this method if the formula is in A1 correct?

 

[Bernard Liengme]

Yes

 

[lizhere]

Thank you!

Yes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

 

[Gord Dibben]

Double-click won't work unless there is contiguous data in an adjacent column.


Gord