Subscribe to our YouTube Channel for more Videos

How to show or hide all comments in Microsoft Excel 2016 ?


This blog post will provide a step by step instruction on how you can show or hide all comments indicators quickly in Microsoft Excel 2016

When we add few comments in excel sheet , you tend to see a little red colored triangle in the top right border of the cell indicating that there is a comment and when we mouse hover on the indicator , the comment box will be displayed showing the comment.

There are times when you might want to quickly view all the comments that are entered in the worksheet.

How to show or hide all comments in Microsoft Excel 2016 ?

Follow the below steps to show all the comments in excel.

#1 – Navigate to the Review Tab in the Excel Ribbon and select the Toggle button “Show All Comments”. This would display all the comments in the excel sheet.

#2 – To hide all the comments in the same excel worksheer click the same “Show All Comments” button again. Its a Toggle button and this will hide all the comments.

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.