Office Settings & Configuration

How to Show Excel AutoFill Options Instead of Quick Analysis

Kushani NimanthikaKushani Nimanthika Nov 3, 2026 871 views

Question details

The user wants to display the AutoFill Options button after dragging the fill handle in Excel, but the Quick Analysis button appears instead.

How to Show Excel AutoFill Options Instead of Quick Analysis
Product
Microsoft Excel
Device & OS
not provided
Scenario
Dragging the fill handle to automatically fill data across multiple cells.
Observed behavior
The Quick Analysis tool button appears at the end of the selection, overriding or hiding the standard AutoFill Options button.
Before you start

Ensure you have an active worksheet open in Microsoft Excel with some sample data to test the drag-and-drop AutoFill functionality after changing your settings.

Solution 1Recommended

Disable Quick Analysis and Enable AutoFill Options

Adjust Excel's General and Advanced settings to prioritize the AutoFill menu over the Quick Analysis tool.

In some cases, Excel prioritizes the Quick Analysis button when you select data or use the fill handle. By turning off the Quick Analysis prompt and verifying that your drag-and-drop settings are enabled, you can restore normal AutoFill behavior.

1
Open Excel Options

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

2
Disable Quick Analysis

In the Excel Options window, select the 'General' tab on the left. Under the 'User Interface options' section, uncheck the box labeled 'Show Quick Analysis options on selection'.

3
Verify AutoFill Settings

Switch to the 'Advanced' tab on the left sidebar. Scroll down to the 'Editing options' section and ensure that 'Enable fill handle and cell drag-and-drop' is checked.

4
Apply and Test

Click 'OK' to save your changes. Select a cell containing data, drag the fill handle (the small square at the bottom-right of the cell) across several adjacent cells, and release the mouse. The AutoFill Options button should now appear correctly.

Disable Quick Analysis and Enable AutoFill Options
Submit Feedback: If you still experience unusual behavior after applying these settings, this may be a known software bug. You can report it directly to Microsoft by navigating to File > Feedback > Send a Frown.
Seamless Data AutoFill in WPS Office

Easily Manage Data with WPS Spreadsheet AutoFill

WPS Spreadsheet provides an intuitive and distraction-free AutoFill feature, allowing you to drag and drop cell data effortlessly without conflicting quick analysis pop-ups. It is highly compatible with Microsoft Excel formats and provides a streamlined user experience.

  1. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet or create a new one.
  2. 2. Select the starting data: Click on the cell or highlight multiple cells containing the data you want to use as a starting point for your fill.
  3. 3. Locate the fill handle: Hover your cursor over the small square located at the bottom-right corner of your selection until the cursor changes to a thin crosshair.
  4. 4. Drag to fill: Click and drag the crosshair down, up, or across the adjacent empty cells where you want the data to appear.
  5. 5. Customize with AutoFill Options: Release the mouse button. The AutoFill Options icon will immediately appear without interference, allowing you to choose whether to copy cells, fill formatting, or fill a series.
Distraction-free AutoFill functionality for quick and reliable data entry.Fully compatible with Microsoft Excel formats, including .xlsx and .xls files.Lightweight architecture ensures it runs smoothly on both new and older devices.Free to use with a familiar interface that requires zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why did Excel replace my AutoFill with Quick Analysis?

Excel's Quick Analysis tool is enabled by default to provide quick access to formatting, charts, and totals. When both features are triggered by a selection, Quick Analysis may overlap or take visual precedence over the AutoFill Options button.

Can I use both AutoFill and Quick Analysis in Excel?

Yes. Even if you turn off the automatic Quick Analysis button in your settings to restore AutoFill, you can still access the Quick Analysis features at any time by selecting your data and pressing Ctrl+Q on your keyboard.

What should I do if the fill handle is completely missing?

If the small square at the bottom-right of your active cell is missing entirely, go to File > Options > Advanced, and ensure the checkbox for 'Enable fill handle and cell drag-and-drop' is checked.

Does disabling Quick Analysis affect my spreadsheet data?

No. Disabling the Quick Analysis pop-up only stops the shortcut button from automatically appearing on screen. Your data, formulas, and all analytical features remain fully intact and accessible through the main ribbon.