Autofill


G

Guest

I'm looking for an autofill option in Excel 2003:
My cell C3 contains the value "sheet1!A1".
I need to autofill the cells C4, to contain "sheet1!A2", C5 to contain
"sheet1!A3" etc.
Which shortcut/option can be used together with the autofill function?

Your help is very much appreciated.
 
Ad

Advertisements

R

Ron Coderre

You have a couple options
1)
Left-Click and Hold on the Fill Handle (the little black box in the lower
right corner of C3)
Drag down as far as you need.....Release the mouse button

or....
2)
Select from C3 down through the last cell to contain a value
<edit><fill><series><autofill>......Click [OK]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
 
Ad

Advertisements

G

Guest

Place your cursor on the edge of the Cell C3, and when it becomes a thiner
dark cross (look alike) then drag the cursor all the way to the last cell
where you want the fill to occur
 

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