Fix Missing Developer Controls and Date Picker in Excel for Mac
Question details
The user is trying to use Developer controls in Excel for Mac but is unable to find the Date Picker or specific drop-down list controls available in the Windows version.

- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Attempting to insert or edit interactive form controls, such as a Date Picker or a drop-down list, into a spreadsheet on a Mac.
- Observed behavior
- The Date Picker is completely missing, and certain Windows-created Content Controls (like drop-down lists) cannot be found or modified within the Mac interface.
Confirm whether the original document contains Content Controls created in Windows, as Mac support for creating or modifying these specific controls is inherently limited by Microsoft.
Use Data Validation to Create Drop-Down Lists
Since Excel for Mac lacks the user interface tools to create Content Control drop-down lists, using the built-in Data Validation feature is the most reliable alternative.
Data Validation is fully supported on Mac and provides a clean, native way to restrict cell entries to a specific drop-down list.
Click on the specific cell or range of cells where you want the drop-down list to appear.
Navigate to the 'Data' tab on the main ribbon menu and click on the 'Data Validation' icon.
In the Allow drop-down box, select 'List'. In the Source box, either select your data range or type out the options separated by commas, then click 'OK'.

Insert Legacy Form Field Controls
If you require an interactive form control object on your sheet rather than standard cell validation, you can use a Legacy Combo Box.
Experience Better Cross-Platform Editing with WPS Office
If missing features in Excel for Mac are disrupting your document workflows, consider switching to WPS Office. It provides a highly compatible, lightweight, and free alternative with excellent cross-platform support.
- 1. Download the software: Visit the official WPS website and download the Mac version of WPS Office.
- 2. Install and launch: Run the installer, follow the on-screen prompts, and open WPS Spreadsheets.
- 3. Open existing files: Drag and drop your existing .xlsx files into WPS to continue working with a robust set of features.

Frequently Asked Questions
Why is the Date Picker completely missing in Excel for Mac?
Microsoft has not included the Date Picker control in the Mac version of Excel. As a result, Mac users must manually enter dates into cells or use the Data Validation feature to create a predefined list of dates.
Can I use Windows-created Content Controls on my Mac?
Yes, Mac Office supports viewing and interacting with Content Controls created in Windows. However, it does not currently provide the user interface tools required to create or modify them directly on a Mac.
How do I show the Developer tab in Excel for Mac?
To enable the Developer tab, open Excel and go to 'Excel' > 'Preferences' from the top menu bar. Click on 'Ribbon & Toolbar', locate 'Developer' in the main tabs list, check the box next to it, and click 'Save'.




