how to execute the fill function down a long column

  • Thread starter Thread starter Harvey
  • Start date Start date
H

Harvey

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
 
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
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
 
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
 
Hanging out in these news groups is where I learned most of the tips and
tricks.


Gord
 
Back
Top