How to hide all notes in Excel at once

Notes in Microsoft Office Excel are some additional information that the user binds to a specific element of a table array or to a range of cells. A note allows you to write more information in one cell to remind you of something. But sometimes notes need to be hidden or removed. How to do this will be discussed in this article.

How to create a note

To fully understand the topic, you first need to learn about the methods for creating notes in Microsoft Office Excel. It is inappropriate to consider all methods within the framework of this article. Therefore, to save time, we present the simplest algorithm for completing the task:

1. Right-click on the cell in which you want to write a note.
2. In the context type window, click LMB on the line “Insert note”.

3. A small box will appear next to the cell, in which you can enter the note text. Here you can write whatever you want at the discretion of the user.

4. When the text is written, you will need to click on any free cell in Excel to hide the menu. An element with a note will be marked with a small red triangle in the upper right corner. If the user moves the mouse cursor over this cell, the typed text will be revealed.

Pay attention! Similarly, you can create a note for any cell in an Excel worksheet. The number of characters entered into the window is not limited.

As a note to the cell, you can use not only text, but also various images, pictures, shapes downloaded from a computer. However, they will have to be tied to a specific element of the table array.

How to hide a note

In Excel, there are several common ways to accomplish the task, each of which deserves detailed consideration. This will be discussed further.

Method 1: Hide a single note

To temporarily remove the label of one specific cell in a table array, you must do the following:

1. Use the left mouse button to select an element that contains a note that needs to be corrected.
2. Right click on any area of ​​the cell.
3. In the context menu that appears, find the line “Delete note” and click on it.

4. Check result. The additional signature should disappear.
5. If necessary, in the same window of the contextual type, click on the line “Edit note” to rewrite the previously typed text, correct the shortcomings.

Method 2. How to remove a note from all cells at once

Microsoft Office Excel has a function to simultaneously remove comments from all elements in which it is present. To take advantage of this opportunity, you must do the following:

1. Select the entire table array with the left mouse button.
2. Move to the “Review” tab, which is located in the top toolbar of the program.
3. In the section area that opens, several options will be presented. In this situation, the user is interested in the “Delete” button, which is located next to the word “Create Note”. After clicking, the signatures will be automatically deleted from all cells of the selected plate.

Important! The method of hiding additional signatures discussed above is considered universal and works in all versions of the software.

Method 3: Use the context menu to hide comments in Excel

To remove labels from all cells in the table at the same time, you can use another method. It consists in doing the following manipulations:

1. According to the similar scheme discussed in the previous paragraph, select the desired range of cells in the table.
2. Right-click on the selected area of ​​the tabular data array with the right mouse button.
3. In the contextual type window that appears, click LMB once on the “Delete note” line.

4. Make sure that after performing the previous step, the labels for all cells are uninstalled.

Method 4: Undo an action

Having created several erroneous notes, you can hide them one by one, delete them using the undo tool. In practice, this task is implemented as follows:

1. Remove selection from the entire table, if it is present, by clicking LMB on the free space of the Excel worksheet.
2. In the upper left corner of the program interface, next to the word “File”, find the button in the form of an arrow to the left and click on it. The action that was performed last should be undone.
3. Similarly, press the “Cancel” button until all notes are deleted.

This method has a significant drawback. After clicking on the considered button, important actions that were performed by the user after creating signatures will also be deleted.

Important information! In Excel, as in any Microsoft Office editor, the Undo action can be performed using a keyboard shortcut. To do this, you need to switch the computer keyboard to the English layout and simultaneously hold down the “Ctrl + Z” buttons.

Conclusion

Thus, notes in Microsoft Office Excel play an important role in compiling tables, performing the function of supplementing, expanding the basic information in a cell. However, sometimes they have to be hidden or removed. To understand how to remove signatures in Excel, you need to carefully read the above methods.