Can't get the Fill Handle to work in Excel 2010

Hi,
Despite having enabled in - Options/ Advanced/ Cut, Copy & Paste, as suggested in Help, I'm unable to get the Fill Handle to work

It had been working all right a few days ago
AMITKHERAsked:
Who is Participating?
 
stevepcguyConnect With a Mentor Commented:
Just wondering if the fill handle was turned off. Try this:

1.Click the File tab, and then click Options.
2.In the Advanced category, under Editing options, verify that "Enable fill handle" and "cell drag-and-drop" are checked on.
0
 
stevepcguyCommented:
"Unable to get the fill handle to work" is vague.

Can you see the crosshairs when you point to the corner of the cell?
Are you able to drag the crosshairs? Does it fill information in the cells?
If so, what information?
0
 
AMITKHERAuthor Commented:
the crosshair has vanished, it used to be visible & working
0
 
AMITKHERAuthor Commented:
thanks it solved the problem, but unable to understand why & how it keeps getting disabled on it's own, the same has happened twice before
please guide if you can
0
 
stevepcguyCommented:
Sometimes a funky keyboard shortcut will turn these types of features on or off. However, I cannot find a reference to turning the autofill handle on/off.

If you're in an enterprise environment, a group policy or add in may be shutting this off. Or maybe a macro. I'd probably have to get my hands on the machine and check it out to track down the issue for certain.
0
All Courses

From novice to tech pro — start learning today.