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


Gord

On Mon, 18 Feb 2008 09:14:02 -0800, lizhere
wrote:

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



"RagDyeR" wrote:

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!
================================================== ===



"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