Here is how to copy (or print) the protected google sheet values.
NOTE: With this technique you can copy the cells from each sheet; it’s not possible to duplicate the spreadsheet file itself. Formatting is preserved but formulas are not.
-
Change the URL to:
https://docs.google.com/spreadsheets/u/1/d/***[document id]***/preview
The document ID is the random string found in the google sheet URL that is normally 40 to 45 characters long.
-
For each sheet, type Ctrl+A, Ctrl+C
-
Paste the cells into another spreadsheet. Formatting