changing behavior of autofill?

K

Keith

In cell A1, I have "Week 1". I would like to be able to
double-click the fill handle and have it fill down "Week
1" in adjacent cells - instead of "Week 2", "Week 3",etc.
I am using excell 2003 and thought with previous versions
I could hold the ctrl key and double click the fill handle
and it would produce the desired result. If I hold the
the ctrl and click and drag the fill handle it works.

Any help you can provide is appreciated!
 

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

Similar Threads

Auto Calculate Question / HELP! 2
VBA word change keys 0
autofill down won't work!!!! 3
AutoFill double click does not work in Excel 2007 2
How do I add a formula to a range of cells 0
dragging formulas acros adjacent cells 3
Autofill Function no longer Working 1
Automatically fill cells when selecting from a drop down list 3

Top