So You Think You Can D̶a̶n̶c̶e̶ Search
p/so-you-think-you-can-d-a-n-c-e-search
Google Search Cheat Sheet
Saijo George
Copy Protected Google Sheets — copy-paste content from a copy protected 🔒 Google Sheet
1
Use the bookmarklet to generate an alternate version of the sheet where the copy protection is not active, so now you can copy the content from the sheet and paste it wherever you want.
Replies
Saijo George
Say, your colleague sends you a Google sheet file or you find a sheet online and want to grab some content from that sheet and paste it into a presentation you are working on or a proposal you are building. And then you see that it’s a protected Google sheet, you try Ctrl+C, you try to make a copy or download it and see that none of those things are possible. You try to ping your colleague to give you edit access or to remove the protection but there is no response. We all have been there, this is a quick trick to solve this issue. This will only work with Google Sheets, it does NOT work with Google Docs or Slides. Use the bookmarklet to generate an alternate version of the sheet where the copy protection is not active, so now you can copy the content from the sheet and paste it wherever you want. Here is a sample protected 🔒 Google Sheet you can try this on: https://docs.google.com/spreadsh... NOTE Regarding Security: It's is not a real security issue, it's more of a convenience thing. If you have access to the sheet you can manually type up the whole thing if you really wanted to this just make it a lot easier.