How to Disable the Fill Handle in Excel

00_lead_image_enabling_fill_handle

If you enter a lot of sequential values in your Excel worksheets, the Fill Handle can help you save time by automatically filling cells with incremented values. What if you find the fill handle doesn’t work?

RELATED: How to Disable the Fill Handle in Excel

By default, the fill handle is enabled, and we’ll show you how to disable it. These same instructions can be used to re-enable it, if you find it got turned off by accident.

To enable or disable the fill handle in Excel, open a new or existing workbook file and click the “File” tab.

01_clicking_file_tab

On the backstage screen, click “Options” in the list of items on the left.

02_clicking_options

Click “Advanced” in the list of items on the left side of the Excel Options dialog box.

03_clicking_advanced

If you want to disable the fill handle, and the “Enable fill handle and cell drag-and-drop” box in the Editing section is checked, uncheck the box. To re-enable the fill handle, just re-check it.

To avoid replacing existing data in cells you are filling using the fill handle, make sure the “Alert before overwriting cells” box is checked, which should be the default. If you don’t want to see the warning dialog, uncheck the box.

04_enabling_fill_handle

Click “OK” to accept the change and close the Excel Options dialog box.

05_clicking_ok_excel_options_dialog

Note that the fill handle displays when you select one or more cells, even when it’s disabled.

Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.