Office for Mac Issues

How to Fix Excel for Mac Autofill Options Button Not Showing

Muhammad TalhaMuhammad Talha Nov 13, 2026 870 views

Question details

The user needs to restore the missing Autofill Options menu in Excel for Mac so they can use Fill Series, Fill Without Formatting, and other fill actions after dragging the fill handle.

How to Fix Excel for Mac Autofill Options Button Not Showing
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
After dragging the fill handle to autofill cells, the expected Autofill Options button no longer appears, blocking access to fill choices.
Observed behavior
The Autofill Options menu is missing or does not show, so Fill Series and Fill Without Formatting cannot be selected from the fill handle.
Before you start

Before troubleshooting, save your workbook and identify the range where you dragged the fill handle. Check your Excel for Mac version in Excel > About Microsoft Excel so you can confirm whether Microsoft 365 is up to date.

Solution 1Recommended

Use Command-Drag or Right-Click to Reopen Fill Options

Use this first when the Autofill Options button disappears after a normal fill-handle drag; it restores access without changing Office settings.

In Excel for Mac, the Autofill Options button can be hidden when the default drag action is applied. Combining the fill handle with the Command key or using the right-click menu exposes the same Fill Series and Fill Without Formatting choices.

1
Hold Command while dragging the fill handle

In Excel for Mac, hold the Command key, then drag the fill handle over the target cells. Release the mouse button and check whether the Autofill Options button appears.

2
Right-click the filled range

If the button still does not show, select the range you just filled, right-click it, and choose Fill Series, Fill Without Formatting, or another available fill option.

3
Use Home > Fill as a ribbon alternative

Click the Home tab, select Fill in the Editing group, and choose Series or other options from the menu.

Use Command-Drag or Right-Click to Reopen Fill Options
Fill options restored: After these actions, you can apply Fill Series or Fill Without Formatting even when the floating button is hidden.
Free Microsoft Office alternative

Avoid Excel for Mac Autofill Issues with WPS Spreadsheets

WPS Office is a free, lightweight Office alternative that opens and saves Excel .xlsx files, includes a familiar ribbon UI and Fill Series tools, and lets you keep using autofill without troubleshooting Microsoft Excel for Mac.

  1. 1. Download WPS Office for Mac: Go to the official WPS website, download the free macOS installer, and complete the installation.
  2. 2. Open your Excel workbook in WPS Spreadsheets: Launch WPS Spreadsheets and open the existing .xlsx workbook; the file remains compatible and you can continue editing.
  3. 3. Use fill handle or Fill options: Select the range, drag the fill handle, or click Home > Fill to access Fill Series and Fill Without Formatting in WPS Spreadsheets.
Built-in fill handle and Fill Series controls in WPS SpreadsheetsOpens and saves Excel .xlsx files without conversionFamiliar ribbon layout and macOS-friendly keyboard supportFree, lightweight, and easy to install on Mac
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Autofill Options button not showing in Excel for Mac after I drag the fill handle?

In Excel for Mac, the button may not appear unless you drag while holding the Command key, or the Office installation may be outdated. Try Command-drag, right-click the filled range, then update Excel via Help > Check for Updates.

How do I use Fill Series when the Autofill Options button is hidden?

Select the filled range, click the Home tab, choose Fill > Series, set the series type and step/stop values, then click OK. You can also right-click the range and choose Fill Series.

Will updating Excel for Mac restore the missing Autofill Options menu?

Often yes. Use Help > Check for Updates in Excel or the Mac App Store to install the latest Microsoft 365 updates, restart Excel, and test the fill handle again.

Can WPS Office open Excel for Mac files and provide autofill options?

Yes. WPS Spreadsheets opens and saves .xlsx files and includes fill handle, Fill Series, and Fill Without Formatting controls, making it a free alternative when Excel for Mac has UI issues.