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!
You should read it
- How to hide, show notes in tables on Excel
- How to delete Comments in Word
- How to write notes, comments on Google Sheets
- How to insert images into the Excel comment box
- How to use comments, notes (comments) in Word
- How to delete comments on Instagram
- Comments in Excel - Create comments in Excel
- Add, create comments in Excel
- Use Comments Tool in MS Excel
- How to insert content annotations on Word
- How to Hide or Delete Comments in Microsoft Word
- How to create notice to delete notes on iPhone
May be interested
How to delete all formulas in Excel fastest
Set a password for Word, Excel, PowerPoint documents in Office 2016
Top 3 best software to reduce Excel file size 2020
Top 3 best PDF file reduction software 2020
Top 3 software to reduce Word file size best 2020
How to fix column and header rows in Excel 2007, 2010, 2013, 2016