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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"lizhere" wrote in message
...
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