How to Remove Comments in Excel (7 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

In this tutorial, I will describe some easy and quick ways to remove comments from Excel sheets. Comments are useful while drafting Excel files. However, finally, when we need to present data, we might be required to delete comments. You can delete them one by one or from the entire worksheet/workbook. So, let’s explore the ways to clear comments.


How to Remove Comments in Excel: 7 Quick Methods

In Excel 365, comments and notes are two separate features. For example, comments are identified as a thread of conversation in Excel 365. On the other hand, notes are the feature that is termed as traditional comments used in other versions of Excel. However, in other versions of Excel comments are the only feature present. While preparing this article, I have used Excel 365.

We have a dataset containing students’ details (Name, ID, Scores). In Cell B8  and C12, there are two notes. And in Cell D7 and D10, we have two comments as well.

7 Easy & Quick Methods to Remove Comments in Excel

1. Delete Comment by Simply Right-Clicking in Excel Cell

You can delete a single comment/note just using a simple right-click of the mouse.

Steps:

  • Right-click on the cell containing the note and click on the Delete Note. Similarly, you can select a cell that has a comment and click on Delete Comment.

Delete Comment by Simply Right-Clicking in Excel Cell

  • As a result, the note will be removed. The same goes for comments too.

Delete Comment by Simply Right-Clicking in Excel Cell

  • Furthermore, you can select all the cells containing both comment and note and click on Delete Comment.

Delete Comment by Simply Right-Clicking in Excel Cell

  • This time, clicking on the Delete Comment option will remove both comments and notes.

Read More: Difference Between Threaded Comments and Notes in Excel


Similar Readings


2. Remove All Comments from Entire Worksheet Using ‘Clear’ Option

Now I will delete comments/notes by using the Clear option in Excel. You can delete a single comment or all the comments in a sheet by applying this option.

Steps:

  • Select the entire worksheet at first, by pressing Ctrl + A.

Remove All Comments from Entire Worksheet Using 'Clear' Option

  • Next, go to the Home > Editing.

Remove All Comments from Entire Worksheet Using 'Clear' Option

  • Go to Clear (Editing group) > Clear Comments and Notes.

Remove All Comments from Entire Worksheet Using 'Clear' Option

  • Consequently, all the comments are gone from the active sheet.

Remove All Comments from Entire Worksheet Using 'Clear' Option

Read More: How to Add Comment in Excel Formula


Similar Readings


3. Add ‘Delete Comment’ Button to Clear Comments (Quick Access Toolbar)

This is one of the quickest options to delete comments. You just have to add the Delete Comment button to Quick Access Toolbar. Moreover, you can delete a single comment/note or all the comments/notes from a worksheet using this option.

Steps:

  • First, click on the Quick Access Toolbar icon under the Excel Ribbon.

Add ‘Delete Comment’ Button to Clear Comments (Quick Access Toolbar)

  • Then, choose the More Commands.

Add ‘Delete Comment’ Button to Clear Comments (Quick Access Toolbar)

  • As a result, the Excel Options window will show up. Next, choose All Commands in the field: Choose commands from. Scroll down and select the Delete Comment option and click on Add Then press OK.

Add ‘Delete Comment’ Button to Clear Comments (Quick Access Toolbar)

  • As a consequence, the Delete Comment icon is added to the Quick Access Toolbar. Now, you can select cells containing comments and click on Delete Comment.

Add ‘Delete Comment’ Button to Clear Comments (Quick Access Toolbar)

  • Finally, all the comments are gone now.

Read More: How to Reference Comments in Excel


Similar Readings


4. Use the ‘Go To’ Option to Remove Comments in Excel

Now, I will apply the Excel Go To option to delete comments.

Steps:

  • Go to Home > Editing.
  • Then go Find & Select (Editing group) > Go To.

  • The Go To dialog box will show up. Click on the Special You can directly bring the Go To window just by pressing F5 from the keyboard.

Use the ‘Go To’ Option to Remove Comments in Excel

  • As a result, the Go To Special dialog box will show up. Click on the Notes. And press OK.

Use the ‘Go To’ Option to Remove Comments in Excel

  • Clicking OK will direct you to the cells that contain Note. Now, right-click on any of the selected cells and click on the Delete Note.

Use the ‘Go To’ Option to Remove Comments in Excel

  • As a result, all the notes in the entire sheet will be removed.

Note:

In Excel 365,  it will not direct you to the cells that contain Comment. So, you cannot delete comments there following this way.

Read More: How to Hide Comments in Excel


5. Excel ‘Review’ Tab to Delete Comments

You can delete comments/notes from the Review tab of excel.

Steps:

  • Select the entire worksheet by pressing Ctrl + A.

Excel ‘Review’ Tab to Delete Comments

  • Go to the Review Click on the Delete option from the Comments group.

Excel ‘Review’ Tab to Delete Comments

  • Comments/notes from the entire sheet are deleted.

Read More: Creating and Editing Excel Comments to Cells


Similar Readings


6. Delete All Comments from a Single Worksheet in Excel

Now I will delete all comments and notes from an entire Excel sheet using VBA.

Steps:

  • Go to the sheet where you want to delete the comments/notes. Right-click on the sheet name and click on the View Code.

Delete All Comments from a Single Worksheet in Excel

  • As a consequence, the Microsoft Visual Basic for Applications window will show up. Write the below code on the Module.
Option Explicit
Sub Delete_All_Comments_From_Worksheet()
Cells.ClearComments
End Sub

Delete All Comments from a Single Worksheet in Excel

  • Run the code by pressing the F5 key and all the comments/notes are gone consequently.


7. Use VBA to Delete All Comments from All Worksheet

I will use VBA  to delete all the comments/notes from an entire workbook. This is an amazing way to remove comments in excel. Suppose, we have a workbook containing comments/notes in two sheets. Now, I will delete all these comments/notes from both of the sheets.

Use VBA to Delete All Comments from All Worksheet

Steps:

  • Open the workbook where you want to delete the comments/notes. Now, right-click on any of the sheets and click on the View Code option.
  • The Microsoft Visual Basic for Applications window will show up. Now, go to the menu bar of that window, click on View > Immediate Window.

Use VBA to Delete All Comments from All Worksheet

  • Now type the below code in the Immediate window.
For each sheet in Worksheets: sheet.cells.ClearComments: Next sheet

Use VBA to Delete All Comments from All Worksheet

  • Then, at the end of the code line, put the cursor and hit Enter.

Use VBA to Delete All Comments from All Worksheet

  • Finally, all comments/notes are now gone from the workbook.


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


Conclusion

In the above article, I have tried to discuss several methods to delete comments in Excel elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.


Related Articles

Hosne Ara
Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo