How To Delete Comments In Microsoft Excel [Tutorial]

Published: 29 July 2021
on channel: MDTechVideos2
307
9

How To Remove Comments In Excel.

Issues addressed in this tutorial:
remove comments excel template
how to remove comments in excel

Whether someone is editing your work or you’re leaving yourself important markers, there’s very little chance that you won’t have to get accustomed to comments in Microsoft Excel.

These dialog boxes come in handy during the drafting phase of any project, but you do want to remove them before using the worksheets during a presentation.

There are three ways to delete comments from your worksheet. You can do it one by one, you can delete all of them at the same time, or you can be selective in your approach.

But not only can you do all that, you can also remove them from three different places in Excel. You can use the Go To function, you can use the Review tab, and you can run a VBA macro.

Knowing all these methods will be helpful if you happen to run across different versions of Excel.

We have previously written about how to add a comment to a cell in Excel , but what if you need to delete a comment after you add it, or there is an existing comment in a spreadsheet that you don’t need anymore? Fortunately you can delete a comment in Excel in a very similar manner to how that comment was first inserted.

This tutorial will show you two different methods for deleting a comment in Excel. The first method will involve using a button in the navigational ribbon, while the second method will have you right-click on the cell with the comment and delete it that way.

This tutorial will apply for Microsoft Excel 2021, 2019, 2013, and 2010 for both Windows (such as Dell, HP, Lenovo, Samsung, Toshiba, Acer, Asus) and macOS (MacBook Air, MacBook Pro, MacBook Mini) devices.


On this page of the site you can watch the video online How To Delete Comments In Microsoft Excel [Tutorial] with a duration of hours minute second in good quality, which was uploaded by the user MDTechVideos2 29 July 2021, share the link with friends and acquaintances, this video has already been watched 307 times on youtube and it was liked by 9 viewers. Enjoy your viewing!