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

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

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

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

Regards,
Stefi


€žMikeR-Oz€� ezt Ã*rta:

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

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

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

Round of applause to you
MIke

"Stefi" wrote:

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

Regards,
Stefi


€žMikeR-Oz€� ezt Ã*rta:

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

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

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

On Sat, 28 Mar 2009 01:06:01 -0700, MikeR-Oz
wrote:

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

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

You are welcome! Thanks for the feedback!
Stefi

€žMikeR-Oz€� ezt Ã*rta:

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

Round of applause to you
MIke

"Stefi" wrote:

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

Regards,
Stefi


€žMikeR-Oz€� ezt Ã*rta:

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