how to execute the fill function down a long column
 

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

how to execute the fill function down a long column
 

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

how to execute the fill function down a long column
 

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

how to execute the fill function down a long column
 

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

how to execute the fill function down a long column
 

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

how to execute the fill function down a long column
 

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