How to delete notes, comments in Excel

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.

How to delete notes, comments in Excel Picture 1

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 .

How to delete notes, comments in Excel Picture 2

You can also find notes by pressing Ctrl + G to open the Go To dialog box . On the Go To dialog box, select Special .

How to delete notes, comments in Excel Picture 3

The Go To Special dialog box appears, select Comments and select OK .

How to delete notes, comments in Excel Picture 4

So all the comments will be selected, you just need to right-click on the comment and select Delete Comment.

How to delete notes, comments in Excel Picture 5

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.

How to delete notes, comments in Excel Picture 6

Delete all notes, comments using macros

Step 1 : In Excel worksheet, select Developer -> Macros.

How to delete notes, comments in Excel Picture 7

Step 2: Enter a name for the macro in the Macro name section , note the name of the macro without accent and select Create .

How to delete notes, comments in Excel Picture 8

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 

How to delete notes, comments in Excel Picture 9

Step 4 : Close the macro and Visual Basic window, you will see the result.

How to delete notes, comments in Excel Picture 10

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.

How to delete notes, comments in Excel Picture 11

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.

How to delete notes, comments in Excel Picture 12

So your notes will be hidden and always hide the red marker icon on the Excel cell.

How to delete notes, comments in Excel Picture 13

To display all the notes again, select Review -> Show All Comments.

How to delete notes, comments in Excel Picture 14

Above is how to delete notes, comments in Excel. Hope the article will help you. Good luck!