0*this Article is about Comments in MS Excel, NOT Notes
Click here to Learn difference between Comments and Notes
You have added many Comments on a Worksheet.
Now, You are unable to track All Comments. OR, it requires You to put lot of effort to track All Comments.
Q) How to see All Comments?
A) Step 1: Click on Review tab
Step 2: See Comments group
Click on Show Comments
Result: All Comments are displayed on right hand side. Please refer following screenshot:
- Cell Address is mentioned in Each Comment.
- You can click on Each Comment to:
1) Edit
2) Reply
3) Delete Thread
4) Resolve Thread
5) In Comments Pane, Scroll Up OR Down to navigate
Q) How to Hide Comments Pane?
A) Again, click on Show Comments
OR
Click on Close icon on top-right corner of Comments Pane
Q) How to Delete All Comments At Once?
A) Step 1: Press Ctrl + A to highlight the entire Worksheet
Step 2: Click on Review tab
Step 3: See Comments group
Click on Delete
Result: All Comments on the Worksheet are deleted
Acknowledgement: Excel Tip.Com
