How to Hide All Comments in Excel (3 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working in an Excel workbook you can add comments in a cell which works as a reminder or explanation. If you insert a comment in a cell, a red triangle will appear at the top of the cell to indicate a comment. This is very helpful if we work with a large dataset and different users use the dataset. Once you add a comment in a cell you can change the format, resize and edit them according to your choice. Sometimes you might want to hide all comments in a worksheet for working advantages. In this article, I will show you how you can hide all comments in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Easy Methods to Hide All Comments in Excel

Hiding all comments is an easy process if you follow the following methods. Following the article, I will explain 3 simple methods to hide all comments in excel.

Suppose we have a dataset of a company’s account workbook where the user added several comments in different cells showing payment history. Now with the help of excel’s built-in feature, I will show you how you can hide those comments quickly.

Hide All Comments in Excel


1. Utilize Review Tab to Hide All Comments in Excel

Using the review option you can hide all comments in excel. Follow the steps below-

Steps:

  • In your workbook click on the review tab.
  • Press the “Show All Comments”.

Utilize Review Option to Hide All Comments in Excel

  • You will see all the comments are hidden. It’s that easy. If you want to get all the comments displayed you can press the “Show All Comments” again to view all comments.

Read More: How to Find Comments in Excel (4 Easy Methods)


Similar Readings


2. Use Format Cell Option to Hide All Comments in Excel

If you want to hide all comments manually then you are in the right place. Go through the steps below-

Steps:

  • From the dataset select a cell where you see a comment. Here I have selected cell (D5).
  • While the cell is selected click the right button on the mouse.

Use Format Cell Option to Hide All Comments in Excel

  • From the pop-up options click the “Hide Comment”.

  • As you can see the comment is hidden according to the command.

Use Format Cell Option to Hide All Comments in Excel

  • Simultaneously, do the steps for all the cells to hide all comments.
  • This way you will be able to hide all comments from your workbook easily.

Use Format Cell Option to Hide All Comments in Excel

Read More: Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!


3. Utilize Excel Options to Hide All Comments in Excel

Sometimes you might feel disturbed by all the comments popping up in the window. In that case, you can hide all the comments and indicators too from your worksheet. In this method, I am sharing with you the process of hiding all comments using the excel options feature.

Steps:

  • Click the “File” tab from the top of your workbook.

Utilize Excel Options to Hide All Comments in Excel

  • Choose options from the left column.

  • A new window will appear.
  • From the new window select “Advanced” and choose “No comments or indicators”.
  • Press OK to continue.

  • Thus you will see we have successfully hidden all comments from our dataset in a small fraction of time.

Utilize Excel Options to Hide All Comments in Excel

Read More: How to Edit Comment in Excel (Including More Features)


Things to Remember

  • While working with format cell options in method 2, you cannot hide all comments selecting all the cells from the dataset. This process works for one selected cell only.

Conclusion

In this article, I have tried to cover all the simple methods to hide all comments in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles


<< Go Back to How to Hide Comments in Excel | Comments in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo