Office Settings & Configuration

How to Fix Excel Fill Handle Missing or Not Visible

Phi Hung Vo Oct 15, 2026 870 views

Question details

The user is unable to see or use the Excel fill handle when a cell is selected, despite the feature being enabled in settings.

How to Fix Excel Fill Handle Missing or Not Visible

Product: Microsoft Excel
Device & OS: not provided
Scenario: Trying to drag and fill data across adjacent cells using the fill handle feature.
Observed behavior: The fill handle (the small square at the bottom right of the active cell) does not appear even when the 'Enable fill handle and cell drag-and-drop' setting is turned on.

Before you start

Ensure your Excel workbook is saved before modifying advanced settings, and verify that you have not applied any sheet protection that might restrict cell editing and formatting.

Solution 1Recommended

Toggle the Enable Fill Handle Setting

Resetting the fill handle and cell drag-and-drop option can resolve glitches where the feature is enabled but not displaying on the interface.

Sometimes Excel's advanced configuration settings can encounter temporary display glitches. Disabling and re-enabling the feature forces the interface to refresh the setting.

Open Excel Options

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

Navigate to Advanced Settings

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

Disable the Setting

Under the 'Editing options' section, locate and uncheck the box for 'Enable fill handle and cell drag-and-drop'. Click 'OK' to apply the change.

Re-enable and Restart

Repeat the previous steps to navigate back to the Advanced settings, re-check the 'Enable fill handle and cell drag-and-drop' box, click 'OK', and then restart Excel to see if the fill handle reappears.

Check Your Excel Version: If toggling the setting does not work, check if your Excel version requires an update by going to File > Account > Update Options.

Solution 2

Use the Fill Command on the Editing Menu

If the drag-and-drop handle is still missing or bugged, you can use the built-in Fill tool on the Ribbon as an immediate workaround.

Efficient Spreadsheet Tool

Use the Fill Handle Smoothly in WPS Spreadsheet

WPS Office provides a highly compatible and intuitive Spreadsheet application where the fill handle works flawlessly out of the box, helping you easily drag and fill data without complex troubleshooting.

1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing spreadsheet containing your data.
2. Select the Cell: Click on the cell that contains the data, formula, or sequence you want to fill.
3. Hover Over the Corner: Hover your cursor over the bottom-right corner of the selected cell until the cursor changes into a solid black cross (the fill handle).
4. Drag to Fill: Click and drag the cross down, up, left, or right across the adjacent blank cells you want to populate, then release the mouse.

Smooth and reliable drag-and-fill functionalityFully compatible with Microsoft Excel (.xlsx) formatsLightweight application that runs fast on any deviceFree to download and use for everyday tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel cursor turn into a white cross instead of a black one?

A white cross is the default selection cursor in Excel. To use the fill handle, you must hover precisely over the small green square at the bottom-right corner of the active cell until the cursor changes to a thin black cross.

Can I permanently disable the fill handle if I don't want to use it?

Yes, you can disable it by navigating to File > Options > Advanced, and unchecking 'Enable fill handle and cell drag-and-drop' under the Editing options section.

Does the fill handle work for custom lists and sequences?

Yes, the fill handle can automatically populate predefined custom lists such as days of the week, months, or any custom sequences you have added to your Excel settings.

Office App Problems