3 Ways to Delete Excel Comments

by

Comments are a great way to add additional information or explanations to cells in your Excel sheet. However, sometimes you may want to delete comments for various reasons, such as cleaning up your sheet, updating outdated information, or just getting rid of unnecessary comments.

In this guide, we’ll show you three easy ways to delete comments in Excel. Whether you have one comment or many, these methods will help you effectively remove them and keep your sheet organized.

METHOD 1

This method uses the “Delete” button in the “Review” tab to remove comments from cells in Excel. This is a simple and straightforward way to delete comments, especially if you only have one or a few comments to remove

  1. In the “Review” tab, look for the “Delete” button and click on it.
  2. The comment should now be deleted from the cell. To verify, right-click on the cell and select “Show/Hide Comment” again.
  3. If the comment is still visible, try the next method to delete it.

Note: If the comment is part of a group of comments, the “Delete” button may not be available. In this case, you’ll need to delete the comments one by one or use one of the other methods discussed in this guide.

METHOD 2

This method uses the Excel Options window to hide comments in the sheet. This method is especially useful if you have multiple comments on the sheet and don’t want to delete them one by one.

  1. Click on the “File” tab in the Excel ribbon.
  2. Select “Options” from the dropdown menu.
  3. In the Excel Options window, click on the “Advanced” tab.
  4. Scroll down to the “Display options for this worksheet” section.
  5. Tick the option next to “No comments, notes, or indicators”.
  6. Click “OK” to apply the changes and close the Excel Options window.
  7. The comments in the sheet should now be hidden. To verify, right-click on a cell with a comment and select “Show/Hide Comment”.
  8. If the comments are still visible, try another method to delete them.

Note: This method will hide all comments in the sheet and may not be the best option if you only want to delete specific comments. However, if you need to remove all comments from the sheet, this is a quick and easy way to do so.

METHOD 3

This method uses the “Data Validation” feature in Excel to remove comments from cells. By clearing the text in the “Input Message” section, the comment is effectively deleted.

  1. Select the cell with the comment you want to remove.
  2. Click on the “Data” tab in the Excel ribbon.
  3. Look for the “Data Validation” option and click on it.
  4. In the “Data Validation” window, select the “Input Message” tab.
  5. Delete the text in the “Input Message” text box or untick “Show input message when cell is selected.”
  6. Click “OK” to close the “Data Validation” window.
  7. The comment in the cell should now be deleted.
  8. Repeat the process for any other cells with comments that you want to delete.

Related Posts: