Table of Contents
This tip is about the how To Delete Comments in MS Excel. So read this free guide, How To Delete Comments in MS Excel step by step. If you have query related to same article you may contact us.
How To Delete Comments in MS Excel – Guide
Comments are very useful when you want to add information to a cell / data point without changing the cell content. I use them a lot when I’m using formulas and I need to specify what a formula does and what a cell value means. When working with others, you can also add comments for others to see. In that tutorial, I’ll show you everything you need to know about comments – including how to insert comments in Excel, edit/delete comments, delete comments from the entire spreadsheet or workbook, etc.
Delete all comments
Suppose you have a dataset as shown below and you want to quickly delete the comment in cell C3.
Below are steps to delete a comment in an Excel cell:
This way, Excel will erase all comments from the selected area.
Delete a single comment
Let’s say you have the following table of data with comments in cells B4, D3 and D5.
Using any of these three options, the comment for cell B4 is deleted and the purple comment sign in the upper-right corner of the cell will disappear.
Final note
I hope you like the guide How To Delete Comments in MS Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.