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