How To Delete All Comments In A Worksheet At Once in Excel

preview_player
Показать описание
How to Delete All Comments in A Worksheet at Once in Excel?
Step 1: Select “Find & Select” under the “Home” tab.
Step 2: Click on “Go To.”
Step 3: Select “Special.”
Step 4: Select “Comments” and Click “Ok.”
Step 5: Right click on any cell with comment
Step 6: Click on Delete Comment.
Done. In this way you can get rid of pop up comments in excel. This procedure will delete each comment from your worksheet. In the next tutorial we will learn how we can remove ell comments from a workbook.

#Delete #Comments
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:
Рекомендации по теме
Комментарии
Автор

thank you. this was really helpful. You just saved us extra hours for notes deletion.

guka-akf
Автор

Thank you. FYI in my version of Excel the box you have as "Comments" is shown as "Notes" other than that it worked great!

mikeb
Автор

Gosh! You just saved one hour of my work! Thank you!!

TTimeFTM
Автор

Thank you! You solved a problem I could not resolve

fluidafrica