Copying a formula down 20K rows

  • Thread starter Thread starter lizhere
  • Start date Start date
L

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
 
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
 
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
 
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
 
Back
Top