I usually create Google Sheets that have several tabs. Usually the audience of each tab should be completely separate.

However it makes sense to keep these tabs in the same sheet since I like to have a final summary tab that aggregates data from all these sheets.

Is there a way to share the same Google Sheet but by giving different viewing rights to each tab?

I thought that restricting a sheet would work. Turns out that this is only about who can edit a sheet. Here are the instructions:

click on tab > protect sheet > set who can see the sheet

sheet menu


1 Answer 1


A solution to this problem is simply creating different spreadsheets, and then having a "summary" spreadsheet that references those other spreadsheets using the method described in this Google forum post.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.