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

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??

HI Gord,

"in Name Box enter A1:A2345 and Enter Then CTRL + D"

you are genius .......... great
from where did u learn such great things to do in short ??


"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??

Hanging out in these news groups is where I learned most of the tips and
tricks.


Gord

On Thu, 3 Sep 2009 21:02:04 -0700, YESHWANT
wrote:

HI Gord,

"in Name Box enter A1:A2345 and Enter Then CTRL + D"

you are genius .......... great
from where did u learn such great things to do in short ??


"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??

Gord
Your first answer was good enough for my situation but the second didnt
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??

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??