How to hide, show notes in tables on Excel

To be able to clarify the content, the built-in features for creating notes or commits on Excel and Word will help users to do that. When you want to highlight important information, explain the content, . but do not want to display much in a column or line, you can create notes for that content. And viewers will immediately see the note when opening the data sheet, statistics on Excel.

However, in the case of multiple data sheets and all notes are displayed, it will be uncomfortable for viewers. Therefore, it's best to hide the notes created on Excel. The following article will guide you in detail how to read or hide the notes in Excel.

1. MS Excel - Lesson 4: Working with lines, columns, sheets
2. How to temporarily hide rows and columns in Excel 2013
3. Change color between different lines in Microsoft Excel

Hide instructions, show notes on Excel

Step 1:

In the Excel data sheet interface, if you want to hide the notes you created, click the Review tab and uncheck it at Show All comment .

How to hide, show notes in tables on Excel Picture 1

Soon, the note was hidden in Excel. For notes or columns with notes, you will see a red mark icon marked as shown. To see the contents of the note, it is okay to hover over the content.

How to hide, show notes in tables on Excel Picture 2

Step 2:

To re-display the note , we also click on the Review tab and click again on Show All comment .

How to hide, show notes in tables on Excel Picture 3

In addition there is another way to set the feature to hide or show annotated content in Excel, which is done in Excel Options. Cick on the Office icon in the top left corner of the interface, then select Excel Options .

How to hide, show notes in tables on Excel Picture 4

Switch to the option list. Here, click on the Advanced item in the list to the left of the interface.

How to hide, show notes in tables on Excel Picture 5

Looking at the content on the right, scroll down to Display . You select the item No comments or indicators then click OK to save.

How to hide, show notes in tables on Excel Picture 6

This method will hide the notes on the Excel data sheet, and do not appear the red mark icon on the content with annotations. To re-display, we just need to tick to Show All comment.

How to hide, show notes in tables on Excel Picture 7

The above is a way to hide or show notes on the Excel data sheet. The Excel comment customization is very simple and we will do it right on the Review tab, the feature is available on the Ribbon. In case the user wants to hide the notes completely, including the red mark, it should be done directly in Excel Options according to the article above.

Video tutorial hidden, showing Excel notes

I wish you all success!