remove all comments at once

Tammy Sellers

I saw your post on how to remove all attachments and that worked great for me. That does not seem to apply to comments. Is there a way to remove all comments at one time?

Andrée Starå

Hi @Tammy Sellers

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

As a possible workaround, you could save the sheet as new and remove the comments before saving it.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

jim.plummer24501

The workaround is:

1. Save As... to create a new copy of your sheet.
2. Select all rows of your sheet (using Shift + Left Mouse click) from first row to last row.
3. Right Click to Copy all Rows (or Ctrl+C)
4. Go to Row 1, and select that row
5. Right Click and Paste (or Ctrl+V)
6. This inserts all rows/cells again without comments
7. Delete the original rows that had the comments.

Tammy Sellers

Ha-Ha. What a good idea!

Andrée Starå

@jim.plummer24501

Nice workaround! 👍️