Is there some way to remove all cell comments from a sheet without having to do it manually one by one?
Is there some way to remove all cell comments from a sheet without having to do it manually one by one?
hi ktalamantez, welcome to the forum. you don't need VBA for this. but if you wish to, record these actions:
1. press F5 or CTRL + G
2. click on Special
3. Comments is selected by default. click OK
4. All comments are now selected. go to the Home tab -> Clear -> Clear Comments
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Try this...
• F5...Click: Special...Select: Comments...Click: OK
While all of the comment cells are selected...
• Right-click one of the comments...Select: Delete Comment
Now ALL of them should be gone.
Does that help?
Ctrl+A highlight the entire sheet, click on Review tab and click on Delete Comments.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks