how to execute the fill function down a long column

H

Harvey

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

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
 
Y

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

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
 
G

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
 
G

Gord Dibben

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


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top