how to execute the fill function down a long column

[Harvey]

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

 

[Gord Dibben]

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

 

[YESHWANT]

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

 

[Harvey]

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]

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

Edit>Fill>Series>Linear>step Value of 1

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

Enter a 1 in A1, a 2 in A2

Edit>Fill>Series>Autofill


Gord Dibben MS Excel MVP

 

[Gord Dibben]

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


Gord