How to Display or Hide the Fill Handle in Excel 2010

It is a common thing in Excel 2010 to fill a group of cells with the same value, or to fill a group of cells with a sequence. This can save you a lot of time, and it can help to avoid mistakes. This functionality is made possible with the help of the Fill Handle, which is displayed at the bottom-right corner of a selected cell.

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.

  1. Open Microsoft Excel 2010.
  1. Click the File tab at the top-left corner of the window.
click the file tab
  1. Click the Options button in the column at the left side of the window.
click the options button
  1. Click the Advanced tab at the left side of the Excel Options window.
click the advanced tab
  1. Scroll down to the Editing options section of the window, then check the box to the left of Enable fill handle and cell drag and drop if you wish to use the fill handle tool. If not, uncheck the box. In the image below, the fill handle is enabled. Once you have finished making your changes, click the OK button to close the window.
turn the fill handle option on or off

Now that you know how to hide or display the fill handle in Excel 2010, you can adjust this setting based on how you are currently using the application to edit your spreadsheets.

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.

Join Our Free Newsletter

Featured guides and deals

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