Office Settings & Configuration

How to Remove AutoFill Pop-Ups in Microsoft Excel

Maira Mehtab Oct 22, 2026 868 views

Question details

The user wants to remove or hide the AutoFill Options pop-up that appears after dragging a cell to fill adjacent cells, as it obscures other worksheet data.

How to Remove AutoFill Pop-Ups in Microsoft Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Dragging a cell's fill handle to copy data or extend a series to adjacent cells.
Observed behavior: The AutoFill Options menu automatically pops up and overlays adjacent cells, blocking information in neighboring columns that the user needs to reference.

Before you start

Please note that hiding the AutoFill Options button in Microsoft Excel requires disabling the drag-and-drop fill handle entirely, meaning you will need to rely on keyboard shortcuts or ribbon commands to quickly copy formulas and fill data.

Solution 1Recommended

Disable the Fill Handle and Cell Drag-and-Drop Feature

Turning off the fill handle in Excel's Advanced Options prevents the AutoFill Options pop-up from appearing entirely.

In Microsoft Excel, the AutoFill Options pop-up is tied directly to the fill handle feature. Because they cannot be managed independently, you must disable the fill handle to stop the pop-up from obscuring your data.

Open Excel Options

Click on the 'File' tab in the top-left corner of the Excel ribbon, then select 'Options' at the bottom of the left-hand menu.

Navigate to Advanced Settings

In the Excel Options dialog box, click on 'Advanced' in the left pane to view advanced editing features.

Disable the Fill Handle

Under the 'Editing options' section, locate and clear the checkbox labeled 'Enable fill handle and cell drag-and-drop'.

Apply and Save Changes

Click the 'OK' button to apply the changes. The AutoFill pop-up will no longer appear, and the drag-to-fill functionality will be turned off.

Disable the Fill Handle and Cell Drag-and-Drop Feature

Alternative to Drag-and-Drop: With the fill handle disabled, you can still fill data rapidly by highlighting the target cells and using keyboard shortcuts like Ctrl+D (Fill Down) and Ctrl+R (Fill Right).

Free Microsoft Office alternative

Experience Cleaner Data Entry with WPS Office

If disabling Excel's fill handle disrupts your workflow just to hide an annoying pop-up, consider switching to WPS Office. It offers a lightweight, highly compatible spreadsheet tool with a streamlined interface that minimizes obstructive overlays.

1. Download and Install WPS Office: Get the free installation package from the official WPS website and install it on your computer.
2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx or .xls file to experience seamless, 100% format compatibility.
3. Use the Fill Handle Smoothly: Drag the bottom-right corner of a cell to fill data instantly without dealing with bulky overlay pop-ups that block your view.

Fully compatible with all Microsoft Excel formats (.xlsx, .xls, .csv).Clean and intuitive user interface without overly intrusive floating pop-ups.Free to download and use with lightweight system requirements.Advanced drag-and-drop cell filling that respects your workspace visibility.

microsoft office alternative - wps office

Frequently Asked Questions

Can I hide the AutoFill Options pop-up without disabling the fill handle entirely?

No. In Microsoft Excel, it is not possible to disable the AutoFill Options pop-up independently. You must disable the 'Enable fill handle and cell drag-and-drop' setting completely, which removes both the pop-up and the ability to drag-to-fill.

How do I fill cells if the fill handle is disabled?

You can use built-in keyboard shortcuts to fill cells. Select the cell with the source data and the adjacent cells you want to fill, then press Ctrl+D to fill downwards or Ctrl+R to fill to the right. You can also use the 'Fill' button located in the Home tab's Editing group.

Will disabling the fill handle affect my existing formulas?

No, disabling the fill handle and cell drag-and-drop only changes how you input or copy new data using your mouse. All existing formulas, formatting, and worksheet calculations will remain fully functional and unaffected.

How do I turn the fill handle back on if I need it later?

To re-enable the fill handle, go to File > Options > Advanced, navigate to the 'Editing options' section, and check the box for 'Enable fill handle and cell drag-and-drop'. Click OK to instantly restore the feature.

Office App Problems