Ampler inserts a comment at the cursor and manages every comment in the workbook — show, hide, or remove all of them from one dropdown.
Quick answer: Select a cell and click Insert comment (Ctrl+Shift+R) on the Ampler ribbon; use the dropdown to show, hide, or delete all comments in the workbook.
How to use it
Insert a comment, or show/hide/remove all comments from the dropdown.
- Select a cell where you would like a comment.
- Click Insert comment (Ctrl+Shift+R).
- Use the dropdown to show, hide, or delete all comments in the workbook.
Managing every comment from one place keeps a workbook’s review notes under control.
Keyboard shortcut
Insert comment is Ctrl+Shift+R by default; you can reassign it in the Ampler Settings → Shortcuts.
Why use it
Comments accumulate across a workbook during review, and Excel gives no quick way to show or clear them all. Ampler inserts a comment at the cursor and shows, hides, or removes every comment in the workbook from one dropdown.
How consultants use it
Models go through review, and the comments used to mark issues must be visible during review and cleared before the model is shared. Three habits apply:
- Mark issues in review: comments flag questions and to-dos on the model.
- Show or hide in bulk: all comments are revealed for review and hidden to read.
- Clear before sharing: removing all comments leaves no review notes on the shared file.
Managing comments in bulk keeps the review cycle tidy.
Tips & best practices
- Show all comments during a review pass.
- Remove all comments before sending or presenting.
- Pair with Clean workbook for a full pre-send tidy.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you add a comment to a cell in Excel?
Select the cell and click Insert comment (Ctrl+Shift+R) on the Ampler ribbon.
How do you show or hide all comments in Excel?
Use the Ampler comment dropdown to show, hide, or delete all comments in the workbook at once.
How do you remove all comments from a workbook?
Choose delete-all-comments from the Ampler dropdown to clear them in bulk.