I was assuming a formula in A1 when giving instructions.

For a series of incrementing numbers..................

Enter 1 in A1

In namebox type A1:A5000 and Enter

EditFillSeriesLinearstep Value of 1

OR...........

Enter a 1 in A1, a 2 in A2

EditFillSeriesAutofill


Gord Dibben MS Excel MVP


On Fri, 4 Sep 2009 07:53:01 -0700, Harvey
wrote:

Gord
Your first answer was good enough for my situation but the second didn’t
seem to work. Could you expand your steps using the following example
You have a file with 5000 rows of information and you want to number each
row 1 to 5000.
Thanks,
Harvey

"Gord Dibben" wrote:

If an adjacent column is filled, just double-click on the fill handle to
copy down.

Or in Name Box enter A1:A2345 and Enter

Then CTRL + D


Gord Dibben MS Excel MVP

On Thu, 3 Sep 2009 15:03:01 -0700, Harvey
wrote:

how to execute the fill function down a long column with out having to drag
the mouse all the way down??