Google-sheets – How to print comments of a Google Spreadsheet

google sheetsprinting

Can I print the comments of a Google Drive spreadsheet? And if yes, how? I should mention that the print should not be on the same page.

Best Answer

You may not have direct option to print comments from the Google Spreadsheet. But look at this work around and try the steps to take out the comments to print alone:

You need you to download the Google Spreadsheet as .xls or xlsx file in your local machine.

  1. Press Ctrl+P, this will open Print option page
  2. Select "Page Setup" option
  3. Go to 'Sheet' tab

enter image description here

  1. Select "At end of the Sheet" option from the 'Comments' dropdown list box and click OK
  2. Now, you will be able to see all the 'Comments' moved in to the last pages of the spreadsheet in the "Print Preview" mode.
  3. Now, apply the From and To pages to print Comments alone as your print document

enter image description here

Related Topic