Spreadsheets

Can you share just one tab of a Google Sheet? Workarounds that work

Google Sheets shares a whole file, not one tab. Here are three workarounds, a separate file via IMPORTRANGE, a values copy and a PDF, with the risk of each.

Editorial illustration for Can you share just one tab of a Google Sheet? Workarounds that work

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?

MethodPrivate tabs reachable?Stays up to date?Main risk
Separate file via IMPORTRANGENo, unless you share the master by mistakeYesBreaks if the master's tab or range changes
Values-only copyNo, they are deleted from the copyNoStale numbers; leftover comments
PDF of one tabNoNoForwarded 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

  1. Keep personal tabs such as loans, account numbers and salary in the master only.
  2. Never share the master link to a group chat.
  3. Review who has access to each file at the end of every financial year.
  4. Make a dated copy of the master before big changes.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports