How to copy from a protected Google sheet in four steps?

Google Sheets plays an important role in Netpeak. They make your work clear, structured, and transparent. Here is another useful tip.

Protecting a sheet prevents you from downloading it or even copying some of its contents in the usual way. The following message appears when you try to copy it:

How to bypass this protection?

Open the protected sheet:

Switch to table preview mode. Replace everything from edit to preview in the URL:

Result:

Note: a large sheet may take a while to open because it's a large HTML file.

Select and copy the content as usual: Ctrl+A Ctrl+C.

Paste it into a new sheet:

Done. You've got a table almost identical to the original one, with little adjustments to format.

Check out our list of digital marketing terms. You can then read Netpeak Journal articles with confidence and ease.
Topics:
9
3
Found a mistake? Select it and press Ctrl + Enter