Solved

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

Posted on 2013-06-14
5
482 Views
Last Modified: 2013-06-14
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
0
Comment
Question by:AMITKHER
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:stevepcguy
Comment Utility
"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
 

Author Comment

by:AMITKHER
Comment Utility
the crosshair has vanished, it used to be visible & working
0
 
LVL 8

Accepted Solution

by:
stevepcguy earned 500 total points
Comment Utility
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
 

Author Comment

by:AMITKHER
Comment Utility
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
 
LVL 8

Expert Comment

by:stevepcguy
Comment Utility
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

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now