'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel for Mac Comment Commands Greyed Out
Question details
Users are unable to insert, edit, or view comments in an Excel workbook because the comment commands are greyed out and unclickable on a Mac.
- Product
- Excel for Mac
- Device & OS
- macOS
- Scenario
- Attempting to annotate cells or collaborate using the comment or note features in an existing Excel spreadsheet.
- Observed behavior
- The comment-related options in the ribbon menu and right-click context menu are entirely greyed out and unavailable.
Verify if the current Excel workbook is opened as a Read-Only file, as all editing functions, including inserting comments, will be disabled until you duplicate and save the file.
Convert Workbook to a Modern Excel Format (.xlsx)
Older file formats (.xls) open in Compatibility Mode, which actively disables modern threaded comments. Upgrading the file format restores these commands.
Excel for Mac separates comments into two distinct features: modern threaded 'Comments' and legacy 'Notes'. Modern threaded comments are strictly unsupported in older .xls file formats.
When an older file is opened, Excel enters Compatibility Mode, freezing access to the newer tools. Converting your file to the current standard format resolves this limitation.
With your workbook open, go to the top menu bar, click on 'File', and select 'Save As' from the dropdown menu.
In the File Format dropdown menu, choose 'Excel Workbook (.xlsx)' rather than an older format.
Click 'Save'. Close the newly saved workbook entirely, then reopen it to refresh the ribbon and reactivate the comment commands.
Disable Worksheet or Workbook Protection
Worksheets can be locked by their authors to prevent unwanted edits. Removing this protection restores the ability to add comments.
Insert Legacy Comments via 'New Note'
If you must keep the document in an older format, you must use legacy 'Notes' instead of the modern 'Comments' command.
Switch to WPS Office for a Seamless Mac Spreadsheet Experience
Avoid compatibility headaches and missing features in Excel for Mac. WPS Office provides a free, highly compatible, and lightweight alternative with native support for modern spreadsheet features, including robust commenting and cell notes.
- 1. Download WPS Office: Visit the official WPS Office website and download the macOS installation package.
- 2. Install the Application: Run the downloaded file and drag the WPS Office icon into your Applications folder.
- 3. Open Your Excel File: Launch WPS Spreadsheet and seamlessly open your .xlsx or .xls file to easily add or edit comments.
Frequently Asked Questions
Why is the 'New Comment' button completely greyed out in my Excel file?
The file is most likely saved in an older format (.xls), which forces Excel into Compatibility Mode. Modern threaded comments require the newer .xlsx format to function. Saving your file as .xlsx will activate the button.
What is the difference between a Note and a Comment in Mac Excel?
In modern Excel versions, a 'Comment' supports threaded conversations where multiple users can reply and tag each other. A 'Note' (formerly known as a legacy comment) is merely a static yellow text box used for simple annotations.
How do I add a shortcut key for inserting comments on a Mac?
You can customize shortcuts by navigating to Tools > Customize Keyboard from the Mac menu bar. Search for 'New Comment' or 'New Note' in the command list, and assign your preferred keystroke combination.
Will unprotecting the sheet always fix greyed-out comment options?
If worksheet protection is the root cause, yes. Authors lock sheets to prevent unauthorized edits. However, if the sheet is unprotected and the commands are still greyed out, the issue is likely due to Compatibility Mode or Read-Only file permissions.
