Fix Excel 2016 for Mac Dropdown Lists That Do Not Scroll
Question details
Fix dropdown lists that require multiple clicks or do not display and scroll correctly in Excel 2016 for Mac.

- 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.
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.
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.
Visit Microsoft's official support site, search for Microsoft AutoUpdate for Mac, and download the current installer.
Open the downloaded installer package and follow the on-screen prompts to install Microsoft AutoUpdate.
Open Excel and select Help > Check for Updates. In Microsoft AutoUpdate, install any updates available for your Office installation.
Restart Excel, reopen the workbook, and click the affected dropdown to check whether it opens and scrolls normally.
Enlarge the Excel workbook window
Try this workaround if the dropdown behaves incorrectly when the workbook window is small.
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.

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.




