Share Individual Tabs in Google Sheets

 

If you work in IT, learn how BetterCloud’s Unified SaaS Management platform can help you manage G Suite and other applications. Also, learn how you can 10x your G Suite productivity

We have received a number of emails asking us how to share a single tab of a Google Sheet without sharing the rest of it. As simple as it sounds, Google does not have a direct way to do this. That does not mean it is not possible to do–you just need to get creative.

Sometimes you want to share one tab of a spreadsheet while keeping the other tabs private. Protecting the cells prevents collaborators from editing particular tabs but they can still view the contents, so it is not a valid solution. The ImportRange function in Google Sheets allows you to create a dynamic copy of particular tabs in a spreadsheet that you can share without worrying about collaborators viewing information in the other tabs.

Click here to watch this video on YouTube.

Get the best tips and tricks in your inbox daily