Home Computer Repair How To Delete All Comments in Microsoft Excel

How To Delete All Comments in Microsoft Excel

192

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.