special edit fill-down

  • Thread starter Thread starter davegb
  • Start date Start date
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?
 
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"
 
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.
 
Back
Top