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

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
 
S

Stefi

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

Regards,
Stefi


„MikeR-Oz†ezt írta:
 
M

MikeR-Oz

CHeers Stefi- That was way easier than what I have been doing.

Round of applause to you
MIke
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Dragging a formula in a column 1
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
drag formula down from columns that go acros 3
How do I add a formula to a range of cells 0

Top