[Fixed!] Cannot Delete Comment in Excel (3 Suitable Solutions)

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.

Dataset for When You Cannot Delete Comment 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.

Use Clear Command When you Cannot Delete Delete Comment

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.

Blurred Delete command When you Cannot Delete Comment in Excel

Let’s see how you can solve this problem.

Steps:

  • Firstly, select the cells where you want to delete the comment.

Selecting Cells Where you Cannot Delete Comment in Excel

  • Secondly, go to the Home tab.
  • Thirdly, select the drop-down option from Clear.
  • Then, select Clear Comments and Notes.

Going to Home Tab When you Cannot Delete Comment in Excel

  • Finally, you will see that you have deleted the comments from the cells.

Note: You can also do this by using keyboard shortcuts. After selecting the cells press Alt H E M on your keyboard and the comments will be deleted.

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.

Delete Comment from Draft in Excel

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.

Delete Comment from Draft in Excel When you Cannot Delete Comment

Let’s see the steps to solving this problem.

Steps:

  • In the beginning, select the comment.
  • Then, click on the marked cross button in the following picture.

Selecting Cross Button When you Cannot Delete Comment in Excel

  • 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.

Employ Data Validation to Delete Comment in Excel

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.

Steps:

  • First, select the cell where you have the comment.
  • Then, go to the Data tab.
  • Afterward, select Data Validation.

Using Data Tab When you Cannot Delete Comment in Excel

  • 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.

Data Validation Dialog Box When you Cannot Delete Comment in Excel

  • 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.

How to Delete All Comments from Entire Excel Sheet


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.

Steps:

  • To begin with, go to the sheet where you want to delete comments.
  • Next, select F5 on your keyboard.

Use Go To Feature

  • 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)


Similar Readings


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.

Steps:

  • Firstly, go to the Developer tab.
  • Secondly, select Visual Basic.

Employ Macros to Delete All Comments

  • After that, the Visual Basic Editor window will appear.
  • Go to the Insert tab.
  • Then, select Module.

Note: You can also press Alt + F11 on your keyboard to open the Visual Basic Editor window.
  • 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

VBA code to Delete Comment in Excel

🔎 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.

Conclusion

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.


Related Articles

Mashhura Jahan

Mashhura Jahan

Hey! Welcome to my profile. Currently, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

2 Comments
  1. thank you for helps

    • Dear umit,

      Thanks for your appreciation it means a lot to us.

      Regards
      Shamima Sultana | Project Manager | ExcelDemy

Leave a reply

5 Excel Tips
You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo