Office Settings & Configuration

How to Fix Excel Dragging Cells Showing Formatting Instead of Fill Options

Ayan Masood Oct 16, 2026 869 views

Question details

The user needs to restore standard fill options like Copy Cells or Fill Cells when using the drag-and-drop feature.

How to Fix Excel Dragging Cells Showing Formatting Instead of Fill Options

Product: Excel
Device & OS: not provided
Scenario: Attempting to drag cells using the fill handle to copy data or create a data series.
Observed behavior: Instead of standard fill options, only formatting options appear because the fill handle and cell drag-and-drop feature is disabled in settings.

Before you start

Ensure you have an active worksheet open in Excel so you can immediately test the drag-and-drop feature after modifying the advanced editing settings.

Solution 1Recommended

Re-enable Fill Handle and Cell Drag-and-Drop in Excel Options

Enable this built-in setting to restore standard Copy Cells and Fill Cells options when dragging data across a worksheet.

By default, Excel allows you to drag a cell's corner to copy data or extend a series. If this feature is disabled, dragging may only apply formatting or not work at all. Adjusting the Advanced editing options will fix this issue.

Open Excel Options

Launch Excel, click on the 'File' tab in the top-left corner, and select 'Options' from the bottom of the left sidebar.

Navigate to Advanced Settings

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

Enable Fill Handle

Locate the 'Editing options' section at the top. Check the box next to 'Enable fill handle and cell drag-and-drop'.

Apply and Verify

Click 'OK' at the bottom to save your changes. Select a cell with data, drag the small square at the bottom-right corner, and verify that 'Copy Cells' and 'Fill Cells' are now available in the AutoFill Options menu.

Re-enable Fill Handle and Cell Drag-and-Drop in Excel Options

Settings Applied: Once enabled, the standard AutoFill Options button will appear automatically whenever you drag cells.

Use WPS Spreadsheet for Seamless Data Filling

Effortlessly Drag and Fill Cells with WPS Office

WPS Spreadsheet provides intuitive and fully functional drag-and-drop tools by default, allowing you to copy cells, fill series, and manage formatting without deep menu diving.

1. Download and Install WPS Office: Get WPS Office for free from the official website and install it on your computer.
2. Open your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel workbook.
3. Select and Drag: Click on the cell containing your data. Hover over the bottom-right corner until the cursor turns into a crosshair (fill handle).
4. Choose Fill Options: Drag the handle across the desired cells, then click the small AutoFill Options icon that appears to select 'Copy Cells' or 'Fill Series'.

Intuitive fill handle enabled by default for quick data entry and series expansion.Fully compatible with Microsoft Excel (.xlsx) file formats.Lightweight and runs smoothly on Windows, Mac, and Linux systems.Free to use with a familiar, user-friendly interface that requires zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my AutoFill options disappear in Excel?

The AutoFill options usually disappear if the 'Enable fill handle and cell drag-and-drop' setting is accidentally turned off in Excel's Advanced options, or if workbook calculation is set to manual.

Can I customize what happens when I drag a cell?

Yes. Once you drag the fill handle, an AutoFill Options button appears next to the newly filled data. Clicking it allows you to choose between copying the cell, filling a series, filling formatting only, or filling without formatting.

Is the fill handle available in WPS Spreadsheet?

Yes, WPS Spreadsheet fully supports the fill handle and drag-and-drop features, and it is enabled by default. It functions exactly like Microsoft Excel, ensuring a smooth transition for new users.

What is the keyboard shortcut for filling cells down?

You can select the cell containing the data along with the empty cells below it, then press 'Ctrl + D' to quickly fill the data downwards without needing to use the mouse.

Office App Problems