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

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



Andrew wrote:
>
> 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

Perfect - thank you so much.

Andrew

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

"Dave Peterson" wrote ...
> Tools|Options|Edit Tab|Check allow drag and drop
>
> Andrew wrote:
>> On behalf of someone else
>>
>> She has lost her autofill handle! Tried restarting Excel, tried
>> opening other files, but no luck in getting it back!