You cannot share a single tab of a Google Sheet, because sharing applies to the whole file. Hiding a tab does not change that. The three workarounds that actually work are a separate file that pulls the tab with IMPORTRANGE, a copy that holds only the values you want to show, or a PDF of that one tab.
Why can I not just hide the other tabs?
Hiding a tab only tidies the view. A person with edit access can unhide it, and a person with view access may still be able to reach the data through a copy, a download or a formula that points at it. Protected ranges limit editing, not reading. If a tab is private, it should not be in the file you share.
Workaround 1: a separate file that pulls the tab with IMPORTRANGE
Keep your master file private. Create a new file for sharing. In it, use =IMPORTRANGE("full link of the master file", "Summary!A1:F60") to pull only the range you want to show, and allow access when asked. Share the new file, not the master.
- Stays live: when you change Summary in the master, the shared file follows.
- The people you share with never get access to the master, but they can read the formula and see the master's link.
- If you delete or rename the tab in the master, the shared file breaks.
- Pulled data is only what the range covers, so be exact about the rows and columns.
Workaround 2: a copy with only values
Make a copy of the file with File > Make a copy. In the copy, delete every tab you do not want to share. Before you delete them, select the tab you are keeping and paste its contents back as values only (Edit > Paste special > Values only), otherwise formulas that refer to deleted tabs turn into #REF! errors. Share the copy.
- Safe, because the private tabs truly are gone from this file.
- It does not update. You must make a new copy each time the numbers change.
- A pasted copy may still carry cell comments or notes that mention private things; check them.
Workaround 3: export a PDF of that tab
Use File > Download > PDF, and in the print settings choose the current sheet only. Send the PDF by email or a chat. This is the lowest-risk way to show a table to someone who does not need to work in it, such as a bank officer or a landlord.
- Nobody can edit it by accident.
- The figures are frozen at that moment and cannot be updated.
- Anyone can forward the PDF, so think about who ends up with it.
How do the three compare on risk?
| Method | Private tabs reachable? | Stays up to date? | Main risk |
|---|---|---|---|
| Separate file via IMPORTRANGE | No, unless you share the master by mistake | Yes | Breaks if the master's tab or range changes |
| Values-only copy | No, they are deleted from the copy | No | Stale numbers; leftover comments |
| PDF of one tab | No | No | Forwarded freely; no edits possible |
Which one should I choose?
- For a CA who needs the year's totals once: the PDF, or the values-only copy if they want to work with the numbers.
- For a spouse who needs a live summary: the IMPORTRANGE file.
- For a lender or landlord: the PDF, with only the rows they asked for.
Whichever you pick, name the file so it is obvious which version it is, for example Summary for CA, FY 2026-27 copy, so nobody confuses it with the master later.
Habits that keep the master safe
- Keep personal tabs such as loans, account numbers and salary in the master only.
- Never share the master link to a group chat.
- Review who has access to each file at the end of every financial year.
- Make a dated copy of the master before big changes.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

