1

Does this only work on specific OSes?

2

you are probably seeking a method which will allow you to copy a cell(s) containing a comment(s) and paste such cell(s) in a way to keep those comments. unfortunately, such a method doesn't exist.

the only way to copy comments from a given sheet is to make a global copy of such sheet:

  • go to File
  • select Make a copy...
  • choose Copy comments

1

You cannot copy and paste a cell with the attached comments but you can cut and paste a cell.

1

I also went to this page to get some answers. After seeing that there is no instant way to do it, this is what I did

  1. Download Google sheet files as Excel (the comments will be included in the download)
  2. Make one consolidated Excel file for the worksheets that you want to consolidate (right-click the Tab, Move or Copy (select your new consolidated file)
  3. Upload the file to Google Drive
  4. Open file as Google Sheet
  5. File>Save as Google Sheet
1
  • Works similarly for docs too, Word lets you merge specific elements, like taking just the comments from several files into a master edit. – Andrew Oct 25 '20 at 5:37
0

From Create, view, or save a file (pay attention to step 4)

COMPUTER

Make a copy of a file

  1. On your computer, open a Google Docs, Sheets, Slides, or Forms home screen. Open the file you want to make a copy of.
  2. In the menu, click File and then Make a copy.
  3. Type a name and choose where to save it.
  4. If you want to copy comments from a document, spreadsheet, or presentation, click Copy comments and suggestions or Copy comments.
  5. Click Ok.

The Android/ iOS apps doesn't include the option to Copy comments and suggestions / Copy comments

1
  • need confirmation that there's no other ways to do this? like you cant copy/paste? or right click on a tab/sheet > 'copy to' ? – productiveuser Jul 10 '18 at 17:55
0

As it stands you can't even paste with comments within the same sheet. However, within the same sheet you can, with a little ingenuity, move a section of cells around without losing the comments. The Insert-Cells/Shift and Delete-Cells/Shift options (available by right clicking on a cell or some selected cells) can be used to move a set of cells around on a sheet with the comments intact.

Not the solution to the original problem, but I got here when I searched for the solution to this problem (which I then solved myself), so I figured someone else might too.

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.