Office Settings & Configuration

How to Restore Missing Fill Handle and AutoFill Options in Excel

Elise WilliamsElise Williams Nov 11, 2026 871 views

Question details

The user needs to restore the fill handle and AutoFill series options in Excel, which are currently missing or replaced by a Quick Analysis button.

How to Restore Missing Fill Handle and AutoFill Options in Excel
Product
Excel
Device & OS
not provided
Scenario
Trying to automatically increment a series using the fill handle.
Observed behavior
The fill handle does not show the expected AutoFill options. Instead, a Quick Analysis button appears after dragging.
Before you start

Ensure that you are trying to drag the fill handle (the small green square at the bottom right corner of the selected cell) and not the cell borders.

Solution 1Recommended

Enable Fill Handle and Cell Drag-and-Drop in Options

Re-enable the fill handle feature through Excel's Advanced settings to restore normal AutoFill functionality.

If the fill handle is missing or only the Quick Analysis tool appears when you drag, the cell drag-and-drop setting has likely been disabled in your Excel application options. Turning this back on will restore the expected behavior.

1
Open Excel Options

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

2
Navigate to Advanced Settings

In the Excel Options dialog box that opens, click on 'Advanced' in the left-hand navigation pane.

3
Enable Fill Handle

Scroll down to the 'Editing options' section. Locate and check the box next to 'Enable fill handle and cell drag-and-drop'.

4
Apply and Test

Click 'OK' to save the changes. Select a cell with data, drag the green fill handle at the bottom right corner, and click the Auto Fill Options button that appears to choose 'Fill Series' or 'Copy Cells'.

Enable Fill Handle and Cell Drag-and-Drop in Options
Quick Analysis Button: The Quick Analysis button might still appear alongside the Auto Fill Options button after dragging, but you will now have full access to both features.
Efficient Spreadsheet Management

Use WPS Spreadsheet for Seamless Data AutoFill

WPS Office offers a powerful and free Spreadsheet application that handles data series, AutoFill, and drag-and-drop seamlessly. It is fully compatible with Microsoft Excel formats and provides an intuitive interface for all your data entry needs without complex configuration issues.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and create a new Spreadsheet or open your existing Excel file.
  2. 2. Enter Initial Data: Type the first value or first two values of your series into adjacent cells (for example, type '1' and '2').
  3. 3. Select the Cells: Click and drag to select the cell or cells containing your starting values.
  4. 4. Drag the Fill Handle: Hover over the bottom-right corner of the selection until the cursor turns into a black cross. Click and drag downwards or across to instantly AutoFill the series.
Free and lightweight office suiteFully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Intuitive AutoFill and drag-and-drop features enabled by defaultFamiliar interface with no steep learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Quick Analysis tool appear instead of AutoFill?

The Quick Analysis tool is designed to appear when you select a range of cells with data to offer quick formatting and charting options. If the fill handle is disabled in your settings, only the Quick Analysis tool will show up after you attempt to drag a selection.

Can I completely disable the Quick Analysis button in Excel?

Yes, you can hide it by going to File > Options > General, and unchecking the box for 'Show Quick Analysis options on selection' under the User Interface options section.

Why is 'Fill Series' grayed out or missing in the Auto Fill Options menu?

If 'Fill Series' is missing, Excel might not recognize a logical pattern in the selected cells, or you may have only selected text instead of numbers. Try entering at least two consecutive numbers (like 1 and 2) in adjacent cells and selecting both before dragging the fill handle.

Does WPS Spreadsheet have the same fill handle functionality as Excel?

Yes, WPS Spreadsheet supports standard fill handle features, including copying cells, filling series, and filling formatting only. These functions work identically to Microsoft Excel and are enabled by default.