But the Fill Handle can be turned on or off, which is helpful if you need it but can’t access it, or if you find that you are accidentally dragging the fill handle when you did not want to. The option you need is found on the Advanced tab of the Excel Options window, and we will show you where to find it in our guide below.  

Adjusting the Display of the Fill Handle in Excel 2010

The steps in this article will show you where to find the setting that controls whether or not the fill handle is displayed in Excel 2010. So if you are wondering where the fill handle is, then you can use these steps to turn it on. Alternatively, if you want to get rid of the fill handle, then you can do that as well.  

   

   

        Is there an add-in that was installed in Microsoft Excel that is giving you problems? Click here and learn how to remove an add-in from Microsoft Excel 2010. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.

You may opt out at any time. Read our Privacy Policy

How to Display or Hide the Fill Handle in Excel 2010 - 89How to Display or Hide the Fill Handle in Excel 2010 - 24How to Display or Hide the Fill Handle in Excel 2010 - 85How to Display or Hide the Fill Handle in Excel 2010 - 65