8

There are over 200 comments in our shared Google Sheet files and we need to clean all the comments faster. Deleting the comments one by one by clicking Resolve is a waste of time. Is there another way we can delete all the comments at the same time?

7

You can get rid of all comments in a sheet by duplicating the sheet, deleting the original copy, and then renaming the duplicate back to what the original was called. This preserves all values, formulas, formatting, and notes. Only the comments are gone.

duplicate

Similarly, you can get rid of comments in an entire spreadsheet by copying it and deleting the original. This can be done directly from Google Drive, without even opening the spreadsheet.


As an aside: the script methods .clear({commentsOnly: true}) that appear to be designed for this purpose do not actually work.

Also, there is no "Clear comments" item in the context menu, like there is one for clearing notes:

clear

  • 1
    How about the script method range.clearNote()? – Jerry101 Nov 2 '15 at 22:53
  • 4
    @Jerry101 That one clears notes, as expected. Notes and comments are different things one can add to a cell (black mark for notes, orange for comments). – user79865 Nov 2 '15 at 23:06
  • The problem with duplicating though is that it wipes out your protected ranges, if you have any. You have to choose between one headache or the other. This might explain why everyone still uses Excel. – user190809 Jul 16 '18 at 13:11
  • 1
    @Jerry101 deleting notes: CTRL+A ... LEFT ALT+E ... LEFT ALT+L – user0 Jul 16 '18 at 14:34
  • in latest version(2019) duplciating the sheet will also duplicate the comment – noobsee Nov 8 at 1:36
0
  1. Select All your cells that has comment (or simply the entire sheet)
  2. Edit (Alt+E)
  3. Clear Note (Alt+L)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.