Comments in Excel help you annotate for a data cell or all worksheets, making the document easier to understand even when others use it. But when you don't need the notes, you can delete or hide them entirely on the Excel worksheet. So, how to delete one or all notes in Excel, or completely hide the notes and the red triangle symbols on the cell? Please refer to the following article.
In this article, excel.net.vn will guide how to delete notes and comments in Excel worksheet.
Delete notes, comment using Delete Comment
Select the cell containing notes to delete or if you want to delete all notes in Excel, then press Ctrl + A to select all. Then you select Review -> Delete in the Comment section .
You can also find notes by pressing Ctrl + G to open the Go To dialog box . On the Go To dialog box, select Special .
The Go To Special dialog box appears, select Comments and select OK .
So all the comments will be selected, you just need to right-click on the comment and select Delete Comment.
Delete all comments and comments using Clear Comment
Select the cell containing the note to delete or if you want to delete all the notes in Excel, press Ctrl + A to select all worksheets. Then you choose Home -> Clear -> Clear Comments.
Delete all notes, comments using macros
Step 1 : In Excel worksheet, select Developer -> Macros.
Step 2: Enter a name for the macro in the Macro name section , note the name of the macro without accent and select Create .
Step 3: Enter the code below into Sub . End Sub and select the run icon or press the F5 key .
Sheets.Select Cells.Select Selection.ClearComments
Step 4 : Close the macro and Visual Basic window, you will see the result.
Hide notes
If you just want to hide notes temporarily but do not want to delete notes, you can select the Review tab, click to uncheck Show All Comment . But so, the cells with notes will still be marked with a red icon, if you want to hide the red marked on the notes, then you do the following:
Step 1: Select File -> Options.
Step 2: In Excel Options window, select Advaned in the left menu, then drag the vertical slider on the right to Display . Here you tick the box No comments or indicators -> OK.
So your notes will be hidden and always hide the red marker icon on the Excel cell.
To display all the notes again, select Review -> Show All Comments.
Above is how to delete notes, comments in Excel. Hope the article will help you. Good luck!