How to Restore Missing Fill Handle and AutoFill Options in Excel
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.

- 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.
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.
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.
Click on the 'File' tab in the top left corner of the Excel window, then select 'Options' at the very bottom of the menu.
In the Excel Options dialog box that opens, click on 'Advanced' in the left-hand navigation pane.
Scroll down to the 'Editing options' section. Locate and check the box next to 'Enable fill handle and cell drag-and-drop'.
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'.

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. Open WPS Spreadsheet: Launch WPS Office and create a new Spreadsheet or open your existing Excel file.
- 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. Select the Cells: Click and drag to select the cell or cells containing your starting values.
- 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.

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.




