Document Editing Problems

Can Excel Sheet Protection Allow Comments Without Cell Editing?

Maira Mehtab Sep 22, 2026 868 views

Question details

The user wants to protect an Excel worksheet to prevent changes to the data while still allowing reviewers to insert and edit comments on specific cells.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing an Excel workbook for review where feedback is required via comments, but the underlying cell data must be locked to prevent accidental or unauthorized edits.
Observed behavior: Excel's native sheet protection settings do not offer a separate permission to allow comments while keeping the cell contents locked from editing.

Before you start

Before modifying your worksheet, understand that Excel does not currently have a built-in feature to separate comment permissions from cell editing permissions on locked cells.

Solution 1Recommended

Acknowledge the Limitation and Submit Feedback

Currently, Excel does not provide a direct way to allow comments while blocking edits on protected cells. The official recommendation is to submit a feature request.

Microsoft Excel's sheet protection options are robust but lack granular control for comments. If a cell is locked and the sheet is protected, users cannot add comments to that cell.

To help prioritize this functionality in future updates, users are encouraged to submit this as a feature request directly to Microsoft.

Open Excel Feedback

Open your Microsoft Excel application and click on the 'Help' tab in the ribbon, or go to 'File' > 'Feedback'.

Send a Suggestion

Click on 'Send a Suggestion' or 'I have a suggestion' to open the feedback portal.

Detail Your Request

Explain that you need a sheet-protection permission that allows users to add and edit comments while preventing all other data edits. Submit the form.

Current Status: Until Microsoft implements this feature natively, you will need to rely on structural workarounds like unlocking specific columns for review.

Solution 2

Workaround: Create a Dedicated Unlocked Column for Comments

Since you cannot allow comments on locked cells, you can create a specific unlocked column where reviewers can freely type their feedback.

Free Microsoft Office alternative

Experience Seamless Spreadsheet Collaboration with WPS Office

If Excel's native protection limitations are disrupting your workflow, try WPS Office. It provides a lightweight, highly compatible, and free alternative with intuitive review features designed to streamline your daily tasks.

1. Download the Software: Visit the official WPS website to download and install WPS Office for free.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx workbook.
3. Utilize Review Tools: Navigate to the Review tab to easily manage spreadsheet collaboration and document security.

Fully compatible with Microsoft Excel (.xlsx) files and native formattingLightweight application that opens large collaborative files instantlyFree to use with a familiar, easy-to-navigate interfaceSmooth transition with zero learning curve for existing Office users

microsoft office alternative - wps office

Frequently Asked Questions

Can I use a VBA macro to allow comments on a protected Excel sheet?

While VBA can use the 'UserInterfaceOnly' parameter to allow macros to modify a protected sheet, it does not change the user interface limitations. Reviewers still will not be able to manually right-click and add comments to locked cells through the standard Excel interface.

Does unlocking a cell allow both comments and data edits?

Yes. When you uncheck the 'Locked' property for a cell before protecting the sheet, users are granted full editing access to that cell. They can change the text, formatting, and also add or modify comments.

Are threaded comments treated the same as standard notes in protected sheets?

Yes, in Excel, both standard Notes and modern threaded Comments are restricted if the underlying cell is locked and the sheet is protected without a specific allowance. Since no such allowance exists natively, neither type can be added to locked cells.

Document & File Issues