Clear Comments: Remove All Excel Comments Instantly

Need to remove comments in Excel before sharing a workbook? You can delete comments and notes manually using Excel's built-in tools, or remove them across every worksheet in one click with the XLclick add-in.

Download Excel Add-in

Excel vs. XLclick: The Best Way to Clear Comments

Excel lets you remove comments individually or through built-in review tools, but cleaning a large workbook can take time. XLclick simplifies the process by removing comments and notes from every sheet in one operation, helping you prepare files for clients and colleagues faster.

FeatureNative Excel MethodsXLclick Clear Comments
Remove individual commentsAvailableIncluded in bulk cleanup
Remove comments across multiple sheetsMay require repeated actionsOne-click operation
Remove traditional notesAvailable through native commandsIncluded
Choose specific cellsPossible with manual selectionNo selection required
Ease of useSeveral steps for large workbooksSimple, direct workflow
Protect workbook contentIncorrect selections may affect other contentTargets comments and notes
Undo supportDepends on the operationUndo option registered by the tool

Important: XLclick removes all comments and notes from every worksheet in the workbook, rather than creating a cleaned copy on a new sheet. A confirmation dialog appears before the operation, and an Undo option is registered. However, once you close the file, the removed comments and notes are permanently gone unless you have a saved backup.

Free Ways to Remove Comments in Excel

You can remove comments in Excel without installing an add-in. The best method depends on whether you need to delete a single comment, clean selected cells, or prepare an entire workbook for sharing.

1. Delete a Single Comment or Note

For occasional cleanup, Excel lets you remove individual comments or notes directly from a worksheet. Right-click the cell containing the comment or note and select the appropriate Delete Comment or Delete Note command, depending on your Excel version and the type of annotation.

Limitations: This method works well for a few cells, but it becomes tedious when a worksheet contains dozens or hundreds of annotations. You must locate each one and repeat the process, increasing the chance of overlooking an important comment before sharing the file.

2. Remove Comments from Selected Cells

If you want to clean only part of a worksheet, select the relevant cells and use Excel's review or context-menu commands to delete their comments or notes. In supported versions, you can also use the Review tab to access comment-management features.

Limitations: You need to select the correct range and verify which annotation type you're removing. A selection that is too broad may delete notes you intended to keep, while a narrow selection can leave unwanted comments elsewhere in the workbook.

3. Clear Comments from an Entire Worksheet

To remove annotations from a complete worksheet, select the sheet's data range or the entire sheet, then use the relevant command under Home > Editing > Clear or the Review tab, depending on your Excel version. Make sure you choose the option specifically intended to remove comments or notes.

Limitations: Clearing annotations from one worksheet does not automatically clean every other sheet in the workbook. You may need to repeat the procedure for each tab, which can be inconvenient in files with many worksheets.

4. Remove Comments Across Multiple Sheets Manually

When preparing a large workbook for external sharing, inspect each worksheet and remove any internal notes, draft feedback, or outdated comments. Depending on your Excel version and workflow, grouped worksheets may support certain operations across multiple sheets, but comment-management behavior can vary.

Limitations: Manual cleanup is easy to overlook, particularly in hidden or rarely used worksheets. You should verify the entire workbook before sending it to a client, supplier, or colleague.

Clear All Comments and Notes in One Click with XLclick

About to send an Excel file to a client but it's full of internal notes and draft comments? Clear Comments removes every sticky note from every sheet in one click.

Essential Settings for Clear Comments

Clear Comments Settings

To open Clear Comments, go to the XLclick tab, find the Fix and Clean group, then click Cleaner > Clear Comments.

The tool works instantly across your entire workbook — no settings to configure and no data selection needed.

When you click it, a confirmation dialog appears: This will remove ALL comments and notes from every sheet in the file. An Undo option will be registered. Continue?

Click Yes to proceed. Every comment and sticky note across all sheets is removed in one pass. Click No to cancel without making any changes.

Because an undo option is registered, you can reverse the action immediately if needed — but once you close the file, the comments are permanently gone.

Real-World Scenarios: Top Use Cases for Excel Clear Comments

An Account Manager Sending a Budget File to a Client Without Internal Notes

An account manager built a budget proposal in Excel, adding comments throughout during the internal review — things like needs approval and check this number. When the file was ready to send to the client, she realized the comments were still there, including some that were not meant to be seen.

Clear Comments removed every internal note across all sheets in one click. She sent the file seconds later, confident nothing inappropriate was visible.

A Freelance Consultant Cleaning Up a Deliverable Before Handoff

A freelance financial consultant annotated a client's Excel model with dozens of working comments during the analysis phase. At delivery time, the file had 40+ sticky notes scattered across three sheets — informal, incomplete, and not suitable for a professional deliverable.

Clear Comments wiped all notes from every sheet at once. The model looked clean and professional, with no trace of the working process left behind.

A Small Business Owner Reusing a Template That Had Old Revision Notes

A small business owner reused a previous year's invoice template that still had review comments from her accountant — things like update this formula and confirm VAT rate. Sending a new invoice with those old notes still visible would have looked careless.

Clear Comments cleared the entire file in one click before she filled in the new invoice details. The template was clean and ready to use in seconds.

An HR Team Preparing an Appraisal Form to Distribute to Employees

An HR team built an appraisal form in Excel and added internal planning comments during the design phase — instructions to themselves, draft questions, and reminders. Before distributing the form to 80 employees, every internal comment had to be removed from every sheet.

One click of Clear Comments stripped all notes from the entire workbook. The form was distributed the same day without any manual cleanup across individual sheets.

A Marketing Agency Archiving Campaign Reports With Sensitive Internal Annotations

A marketing agency archived client campaign reports that contained internal performance annotations — candid notes about strategy decisions and client issues. When a new team member accidentally shared an archived file with the client, the comments caused an awkward situation.

After that incident, the agency made Clear Comments a standard step before any file left the building. One click before export ensured no internal note was ever shared unintentionally again.

Author Image
Federico Magni SEO Specialist since 2012

Excel has always been my laboratory. After years of navigating data-heavy workflows, I created XLclick: the definitive add-in that simplifies complex analysis into a single click. It’s built for pros who want to spend less time on spreadsheets and more time on strategy.