HomeMicrosoft OfficeExcelHow to Show or Hide all Comments in Microsoft Excel ?

How to Show or Hide all Comments in Microsoft Excel ?

Ever wondered how you can show or hide comments in Microsoft Excel ?. This blog post exactly shows how you can do it in a step by step manner.

When we add few comments in an excel sheet, we 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 worksheet click the same “Show All Comments” button again. Its a Toggle button and this will hide all the comments.

    1 Comment

  1. User Avatar
    Sandhya
    April 14, 2023
    Reply

    Excel’s ribbon menu for show and hide commands is fairly simple to use, even for beginners.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021