Office for Mac Issues

Fix Missing Developer Controls and Date Picker in Excel for Mac

Phi Hung VoPhi Hung Vo Nov 4, 2026 871 views

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.

Fix Missing Developer Controls and Date Picker in Excel for Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the target cell

Click on the specific cell or range of cells where you want the drop-down list to appear.

2
Open Data Validation tools

Navigate to the 'Data' tab on the main ribbon menu and click on the 'Data Validation' icon.

3
Configure your list items

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'.

Use Data Validation to Create Drop-Down Lists
Date Picker Alternative: Because the Date Picker is not supported in Excel for Mac, you can use this same Data Validation method to create a list of valid dates for users to select from.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS website and download the Mac version of WPS Office.
  2. 2. Install and launch: Run the installer, follow the on-screen prompts, and open WPS Spreadsheets.
  3. 3. Open existing files: Drag and drop your existing .xlsx files into WPS to continue working with a robust set of features.
Seamlessly open, edit, and save Microsoft Excel formats (.xlsx) with full compatibilityConsistent user interface and feature availability across Windows and MacLightweight application that uses fewer system resourcesFree to download and easy to migrate your existing files
microsoft office alternative - wps office

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'.