Permission & Access Issues

How to Prevent Users from Viewing Comments or Notes in Excel

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to know if there is a specific permission or sharing setting to hide comments or notes from other users in a shared workbook.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing an Excel workbook that contains sensitive comments or notes the owner wishes to keep private from collaborators.
Observed behavior: Excel allows anyone with access to the workbook to view all comments and notes by default, lacking a built-in feature to restrict their visibility.

Before you start

Before sharing your workbook, review all existing comments and notes to identify any sensitive information. Since Excel lacks granular comment permissions, you will need to apply workarounds to keep this data private.

Solution 1Recommended

Remove Sensitive Comments Before Sharing

The most secure way to ensure users cannot view private comments is to delete them or save a clean copy of the workbook before sharing.

Because Excel does not currently provide a built-in setting to restrict comment visibility based on user permissions, removing the comments entirely from the shared version is the only foolproof method.

Create a duplicate workbook

Go to File > Save As and save a copy of your workbook specifically for sharing with others.

Open the Document Inspector

In your new copied workbook, go to File > Info > Check for Issues > Inspect Document.

Inspect and remove comments

Check the box for 'Comments and Annotations', click 'Inspect', and then choose 'Remove All' next to the comments section to delete them.

Save and share

Save this clean version of the workbook and safely share it with your team.

Feature Request: Consider submitting feedback to Microsoft via the Help tab to request more granular comment permissions in future updates.

Solution 2

Move Private Notes to a Separate Protected Sheet

Keep your sensitive notes in a dedicated worksheet as plain text and restrict access to that specific sheet.

Free Microsoft Office alternative

Try WPS Office for Secure Document Management

If you need an efficient and reliable way to manage spreadsheets without the heavy subscription fees of Microsoft Office, consider switching to WPS Office. It is a free, lightweight, and user-friendly office suite that offers excellent compatibility with Excel formats alongside robust file protection features.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Your Spreadsheets: Easily open your existing .xlsx files with WPS Spreadsheet without losing any formatting.
3. Manage Security: Use the built-in encryption and protection features under the Review tab to secure your sensitive data.

Fully compatible with Microsoft Excel (.xlsx) formats, formulas, and comments.Advanced document encryption and password protection to keep sensitive data safe.Lightweight software that opens large spreadsheets quickly, even on older devices.Familiar user interface requiring zero learning curve for seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Can I hide the comment indicators in Excel?

Yes, you can hide the red triangle indicators by going to File > Options > Advanced, scrolling down to the Display section, and selecting 'No comments, notes, or indicators'. However, this only hides them on your local screen; other users can easily change this setting back to view them.

Does protecting the worksheet hide comments from other users?

No, protecting a worksheet via the Review tab only prevents users from editing or deleting the comments. It does not hide the comments from being read.

Can I password-protect specific cells containing comments?

While you can lock specific cells to prevent edits and hide their formulas using the Protection tab in the Format Cells dialog, this feature does not hide cell comments or notes from being viewed by collaborators.

Document & File Issues