How to Fix Excel for Mac Autofill Options Button Not Showing
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.

- 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 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.
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.
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.
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.
Click the Home tab, select Fill in the Editing group, and choose Series or other options from the menu.

Update Excel for Mac and Restart to Restore Autofill Options
Use this if the button remains missing after trying Command-drag and right-click options; outdated Office versions can disable UI elements.
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. Download WPS Office for Mac: Go to the official WPS website, download the free macOS installer, and complete the installation.
- 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. 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.

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.




