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.

Table of Contents hide

Download Practice Workbook

3 Easy Methods to Hide All Comments in Excel

1. Utilize Review Tab to Hide All Comments in Excel

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

3. Utilize Excel Options to Hide All Comments in Excel

Things to Remember

Conclusion

Download Practice Workbook

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

Hide All Comments.xlsx

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.

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”.

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.

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.

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

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

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.

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.

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.

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.