Office for Mac Issues

Fix Excel 2016 for Mac Dropdown Lists That Do Not Scroll

Ayan MasoodAyan Masood Nov 20, 2026 868 views

Question details

Fix dropdown lists that require multiple clicks or do not display and scroll correctly in Excel 2016 for Mac.

Fix Excel 2016 for Mac Dropdown Lists That Do Not Scroll
Product
Microsoft Excel 2016 for Mac
Device & OS
Mac, macOS version not provided
Scenario
A user opens a dropdown list in an Excel workbook, especially when the workbook window is small.
Observed behavior
The dropdown may require multiple clicks to open or may not display and scroll correctly.
Before you start

Open the affected workbook and note whether the dropdown problem occurs only when the Excel window is small. Check your Excel version under Excel > About Excel so you can compare it with the latest update available for your installation.

Solution 1Recommended

Update Excel using a fresh copy of Microsoft AutoUpdate

Use this method to install available Office updates that may address older dropdown display and scrolling issues.

Earlier Excel for Mac releases had dropdown display and scrolling issues that were addressed through updates. Office 2016 for Mac is no longer supported, so updates for that version may be limited.

1
Get Microsoft AutoUpdate

Visit Microsoft's official support site, search for Microsoft AutoUpdate for Mac, and download the current installer.

2
Install AutoUpdate

Open the downloaded installer package and follow the on-screen prompts to install Microsoft AutoUpdate.

3
Check for Office updates

Open Excel and select Help > Check for Updates. In Microsoft AutoUpdate, install any updates available for your Office installation.

4
Test the dropdown

Restart Excel, reopen the workbook, and click the affected dropdown to check whether it opens and scrolls normally.

If no update is offered: Office 2016 for Mac has reached the end of support. Microsoft AutoUpdate may not offer further fixes for that version.
Free Microsoft Office alternative

Open spreadsheets in WPS Office for Mac

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open your Excel files in WPS Spreadsheets for an easy transition, although it does not repair Microsoft Excel itself.

Open and edit Microsoft Excel XLSX and XLS filesWork with spreadsheet dropdown lists in WPS SpreadsheetsUse a familiar interface to transition from ExcelAccess free core spreadsheet tools in a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where do I check for Excel updates on a Mac?

In Excel, select Help > Check for Updates to open Microsoft AutoUpdate. Install any updates offered for your Office installation.

What if Check for Updates does not open?

Download and install Microsoft AutoUpdate from Microsoft's official support site, then return to Excel and select Help > Check for Updates.

Why does the dropdown work poorly in a small window?

Earlier Excel for Mac versions had dropdown display and scrolling issues. Try enlarging the workbook window and installing any available Office updates.

Does Microsoft still provide fixes for Excel 2016 for Mac?

Office 2016 for Mac has reached the end of support, so new fixes are not expected. Check Microsoft AutoUpdate for any updates still available to your installation.

Can I open the workbook in WPS Spreadsheets instead?

Yes. Open the XLSX or XLS file in WPS Spreadsheets and test the dropdown there. Some workbook features may behave differently from Excel.