AutoFill Handle disappeared! (Excel 2003)

[Andrew]

Hi

On behalf of someone else, so forgive me if the specifics are... not
that specific.

She has lost her autofill handle! Tried restarting Excel, tried
opening other files, but no luck in getting it back!

Is there some option or setting that we don't know about that would
turn it on or off? She's a very PC savvy person, so I don't think it's
anything obvious, cos she'd have found it!

If anyone can help, we'd be really grateful!

Thanks in advance.

Andrew Richards

 

[Dave Peterson]

Tools|Options|Edit Tab|Check allow drag and drop

 

[Andrew]

Perfect - thank you so much.

Andrew

 

[David McRitchie]

Just for the sake of completeness
missing fill-handle in Excel 2007 click on Office button where File used
to be, then click on Options at the bottom, then on Advanced at the left,
then "Enable fill handle and cell drag-and-drop"

I have a page on use of the fill-handle and the shortcuts that can be used
for fill down and fill across at
http://www.mvps.org/dmcritchie/excel/fillhand.htm