Andrew

Enter a formula in A1.

Select namebox and type in A1:A456 and <ENTER

Now CTRL + D


Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 13:09:02 -0800, Andrew
wrote:

I know that I can copy a formula down a column by clicking and dragging the
auto-fill handle or by double clicking the auto-fill handle, but does anyone
know a way to do that with a short-cut key or command? Thanks,

Andrew