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

On Mon, 18 Feb 2008 08:43:05 -0800, lizhere
wrote:

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