FSA Tip #13 Working With VIEW ONLY Google Spreadsheets

Sometimes you want to share a Google Spreadsheet with someone but you don’t want them to change your version. Maybe you’re sharing an order form (just like in this week’s tip!) with many clients and you need to get back a unique form from each person.

Or you find a fantastic Google Spreadsheet that you would like to use but it’s VIEW ONLY! You would need to request access from the owner to use it. But you just want to experiment with that sheet without delay.

There is a simple step to solve all these problems!

In this tip, we’ll see …

  • How to make a copy of a VIEW ONLY sheet for personal use
  • How to direct your users to make their own copy
  • How to have your users automatically make their own copy

You can download the spreadsheet from this tip!

Do you often need to share VIEW ONLY sheets?


Join me next Thursday at 2pm for my next Farmer Spreadsheet Tip on Facebook Live.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s