Office Settings & Configuration

How to Restore Excel AutoFill Options When Copilot Is Visible

Maira Mehtab Sep 28, 2026 869 views

Question details

The user needs to restore the Excel AutoFill Options button, which appears to be missing or inaccessible when the Copilot icon is visible on the interface.

Product: Microsoft Excel (Microsoft 365)
Device & OS: not provided
Scenario: Attempting to use the drag-and-drop AutoFill feature to populate cells while the Microsoft Copilot feature is active on the screen.
Observed behavior: The AutoFill Options button does not appear after dragging a cell's fill handle, leading the user to suspect that the Copilot button has replaced or hidden it.

Before you start

Ensure you have selected a cell containing a valid formula or data series, as the AutoFill options button will only trigger after a successful drag-and-drop action.

Solution 1Recommended

Enable the Fill Handle and Drag-and-Drop Settings

The AutoFill feature may simply be disabled in your Excel settings. Re-enabling the fill handle will restore the missing button regardless of Copilot's visibility.

In Microsoft 365, the Copilot icon and the AutoFill Options button are completely separate controls. Copilot does not replace AutoFill. The most common reason for a missing AutoFill button is that the drag-and-drop feature was accidentally turned off in the advanced settings.

Open Excel Options

Click on 'File' in the top-left corner of the Excel ribbon, then select 'Options' at the bottom of the menu to open the Excel Options dialog box.

Navigate to Advanced Settings

In the left-hand pane of the Excel Options window, click on 'Advanced'.

Enable the Fill Handle

Scroll down to the 'Editing options' section and check the box next to 'Enable fill handle and cell drag-and-drop'. Make sure 'Alert before overwriting cells' is also checked if you want a warning before replacing data.

Apply and Test

Click 'OK' to save your changes. Select a cell with data, drag the small green square (fill handle) in the bottom-right corner, and verify that the AutoFill Options button now appears.

Settings Applied: Once enabled, the AutoFill button will float next to your filled cells, allowing you to choose between copying cells, filling series, or filling without formatting.

Solution 2

Update Microsoft 365 to Fix Interface Glitches

If the settings are correct but the interface is still misbehaving, updating Office can resolve UI conflicts between Copilot and legacy features.

Free Microsoft Office alternative

Experience Uninterrupted Data Editing with WPS Office

If Microsoft 365 interface updates and AI integrations are cluttering your workspace or hiding essential tools, consider switching to WPS Office. It provides a clean, classic spreadsheet experience where features like AutoFill always work exactly as you expect them to.

1. Download and Install: Download WPS Office for free from the official website and install it on your device.
2. Open Your Spreadsheets: Open your existing .xlsx files seamlessly in WPS Spreadsheet without losing any formatting or data.
3. Use AutoFill Instantly: Select any cell, click and drag the fill handle in the bottom-right corner, and access all AutoFill options immediately without UI conflicts.

100% compatible with Microsoft Excel (.xlsx) file formats.Classic, intuitive interface without intrusive AI buttons replacing core features.Free and lightweight, ensuring fast performance on any device.Built-in, reliable AutoFill and Quick Analysis tools.

Frequently Asked Questions

Does Microsoft Copilot replace the AutoFill button in Excel?

No, Copilot and AutoFill are completely separate features. If your AutoFill button is missing, it is likely due to disabled settings or an interface glitch, not a direct replacement by Copilot.

Why doesn't the AutoFill options box appear after dragging a cell?

This typically happens if 'Enable fill handle and cell drag-and-drop' is turned off in Excel's Advanced Options. You must enable this setting for the AutoFill floating button to appear after dragging.

Can I disable Copilot in Excel to get my old interface back?

Copilot visibility is usually managed by your Microsoft 365 administrator or your specific subscription tier. However, fixing the AutoFill settings directly through the File > Options menu is the best way to restore the missing button regardless of Copilot's status.

Office App Problems