Comments help you to mention something about data. But after you are done with the comments you may want to delete them. Deleting comments is quite an easy task. But sometimes you may face a situation where you cannot delete comment in Excel. The main objective of this article is to provide solutions for this situation.
Download Practice Workbook
You can download the practice workbook from here.
3 Suitable Solutions When You Cannot Delete Comment in Excel
To explain this article, I have taken the following dataset. This dataset contains Student ID, Name, and Percentage. You can see that there are 2 comments in this dataset. I will use this dataset to show you solutions for when you cannot delete commnet in Excel.
Solution-01: Use Clear Command to Delete Comment
You can delete a comment easily by selecting the cell where the comment is and then selecting Delete from the Review tab.
But, in some cases, you can face a situation where you will see that the Delete command is blurred. And for this reason, you will not be able to comment from here.
Let’s see how you can solve this problem.
- Firstly, select the cells where you want to delete the comment.
- Secondly, go to the Home tab.
- Thirdly, select the drop-down option from Clear.
- Then, select Clear Comments and Notes.
- Finally, you will see that you have deleted the comments from the cells.
Read More: How to Remove Comments in Excel (7 Quick Methods)
Solution-02: Delete Comment from Draft in Excel
In the following picture, you can see that I selected a cell that contains a comment but the Delete option is blurred here. So, I cannot delete comment in Excel from here.
The possible reason for this can be not posting the comment. In the following image, you can see that I have inserted the comment into that cell but I have not posted it yet. And, for this reason, I am not able to delete the comment.
Let’s see the steps to solving this problem.
- In the beginning, select the comment.
- Then, click on the marked cross button in the following picture.
- After that, you will see that the comment is deleted.
Read More: Creating and Editing Comments in Excel (4 Practical Examples)
Solution-03: Employ Data Validation to Delete Comment
In some cases, you may find comments like the following picture. These types of comments show only when you select the cell. Otherwise, you can not see them.
If you try to delete this type of comment you will find that the Delete option is blurred here. That means you cannot delete this comment in Excel. The reason behind this is, it is not an actual comment. It is an Input Message box. And, it is inserted using the Data Validation feature.
Let’s see how you can delete these message boxes.
- First, select the cell where you have the comment.
- Then, go to the Data tab.
- Afterward, select Data Validation.
- Consequently, the Data Validation dialog box will appear.
- Select the Input Message tab.
- Next, uncheck the Show input message when cell is selected option.
- Lastly, select OK.
- Finally, you will see that you cannot see that comment when you select the cell. That means you have deleted the comment.
Read More: How to Format Comments in Excel (2 Easy Ways)
How to Delete All Comments from Entire Excel Sheet
In this section, I will explain how you can delete comments from the entire sheet in Excel. Now, before starting this section you must know that Office 365 provides both Notes and Comments. Here, the Comments that you knew in the previous versions of Microsoft Excel are renamed as Notes. And, the Comment provides a conversation thread. So, in this section, I will show you how you can delete these notes from the entire Excel sheet. I have taken the following dataset to explain this section. You can see that two of the cells contain comments (notes). You can see there is a note by the small red triangle at the corner of the cell.
1. Use Go To Feature
The Go To feature can be used to select a cell range. Here, I will use the Go To feature to find and select the comments in the whole worksheet. And then delete them. Let’s see the steps.
- To begin with, go to the sheet where you want to delete comments.
- Next, select F5 on your keyboard.
- After that, the Go To dialog box will appear.
- Then, select Special.
- Consequently, the Go To Special dialog box will appear.
- Select Notes.
- Then, select OK.
- After that, you will see that all the comments are selected in that worksheet.
- Further, Right-click on any of the selected cells.
- Next, select Delete Note.
- In the end, you will see that you have deleted all the comments from the Excel sheet.
Read More: How to Edit Comment in Excel (Including More Features)
- How to Populate Comment from Another Cell in Excel (and Vice Versa)
- Difference Between Threaded Comments and Notes in Excel
- How to Export Instagram Comments to Excel (with Quick Steps)
- How to Read Full Comment in Excel (6 Handy Methods)
- Vlookup to Copy Comments in Excel (with a UDF)
2. Employ Macros to Delete All Comments
You can easily delete all the comments from a worksheet by using Macros. All you need is to write a simple VBA code and you are good to go. Let’s see the steps.
- Firstly, go to the Developer tab.
- Secondly, select Visual Basic.
- After that, the Visual Basic Editor window will appear.
- Go to the Insert tab.
- Then, select Module.
- Now, a module will open.
- After that, write the following code in that module.
Sub Delete_All_Comments_from_Entire_Sheet() ActiveSheet.Cells.ClearComments End Sub
🔎 How Does the Code Work?
- Here, I created a Sub Procedure named Delete_All_Comments_from_Entire_Sheet.
- Then, I used the ClearComments method to delete all the comments from the active worksheet.
- Finally, I ended the Sub Procedure.
- Then, Save the code and go back to your worksheet.
- After that, go to the Developer tab.
- Next, select Macros.
- Now, the Macro dialog box will appear.
- Select Delete_All_Comments_from_Entire_Sheet as the Macro name.
- Then, select Run.
- Finally, you will see that you have deleted all the comments from the whole worksheet.
Read More: How to Remove Pop-up Comments in Excel (4 Suitable Ways)
Things to Remember
- It should remember that if you are working with Macros then you must save your Excel file as Excel Macro-Enabled Workbook. Otherwise, the VBA code will not work.
To conclude, I tried to explain 3 solutions for when you cannot delete comment in Excel. Here, I also explained 2 different ways of deleting all the comments from an Excel sheet. I hope this article was clear to you. For more articles, stay connected with ExcelDemy. Lastly, if you face any problems, feel free to comment in the comment section below.
- How to Copy Comments to Another Cell in Excel (2 Methods)
- [Solved:] Insert Comment Not Working in Excel (2 Simple Solutions)
- How to Copy Comments in Excel (2 Suitable Ways)
- How to Export PDF Comments into an Excel Spreadsheet (3 Quick Tricks)
- Creating and Editing Comments in Excel (4 Practical Examples)
- How to Print Worksheet with Comments in Excel (5 Easy Ways)
thank you for helps
Thanks for your appreciation it means a lot to us.
Shamima Sultana | Project Manager | ExcelDemy