special edit fill-down

D

davegb

I used to know a trick to fill down a column to even with the bottom of
a column to it's left, without dragging all the way down. Does anyone
know this short-cut?
 
T

Tom Ogilvy

click in the top cell - the cell you want to fill down. The highlight
should have a little square in the lower right corner. Double click on
that.

IF it doesn't have the little square, then you need to go into
tools=>Options =>edit tab and enable/check "allow cell drag and drop"
 
D

davegb

Thanks for your reply, Tom. I already know how to do a fill-down. I
figured out how to do what I asked. I put in the first formula, then
did a Cntrl double click in the fill down handle.
 
Top