How to copy formulae down LONG list-other than dragging corner dow

  • Thread starter Thread starter MikeR-Oz
  • Start date Start date
M

MikeR-Oz

Hi,

The column is very long and to drag down the corner of the cell would take a
little while- Is there a better way?

Thanks for the help
Mike
 
Double click when you see the drag down cross at the bottom right corner of
the cell!

Regards,
Stefi


„MikeR-Oz†ezt írta:
 
CHeers Stefi- That was way easier than what I have been doing.

Round of applause to you
MIke
 
If you have continuous data in an adjacent column simply double-click on the
fill handle.

Or with formula in B1..........in Namebox type B1:B12000 and ENTER

Now CTRL + d


Gord Dibben MS Excel MVP
 
Back
Top