How to Hide Columns or Tabs From Specific Users in Google Sheets (What Works)

Google Sheets can’t hide columns or tabs from specific people. Anyone who can open a spreadsheet can unhide hidden columns or sheets, and viewers can even see hidden data by copying the file or downloading it. To keep data private from certain users, put the private data in a separate spreadsheet that only you can access, and share a second spreadsheet that pulls in just the columns they’re allowed to see with IMPORTRANGE. For people who can edit, Protected ranges can stop them from changing data, but not from seeing it.

Below is what hiding and protecting actually do, the method that really keeps columns private, and options for sharing a filtered view.

What hiding and protecting can and can’t do

Feature Hides data from others? Stops editing?
Hide column or sheet No, anyone can unhide it No
Protected range or sheet No Yes, for people you choose
View-only sharing No, viewers see all sheets Yes
Separate spreadsheet with IMPORTRANGE Yes Yes

Keep columns private with a second spreadsheet

  1. Keep your full data in the original spreadsheet. Don’t share it with the people who shouldn’t see everything.
  2. Create a new spreadsheet for sharing.
  3. In cell A1 of the new spreadsheet, enter a formula that imports only the allowed columns, for example:
    =IMPORTRANGE(“original_spreadsheet_url”, “Sheet1!A:C”)
  4. Click Allow access when prompted to connect the two files.
  5. To import non-adjacent columns, use QUERY, such as =QUERY(IMPORTRANGE(“url”,”Sheet1!A:F”), “select Col1, Col2, Col5”).
  6. Share only the new spreadsheet with the other people.

The shared file updates automatically when the original changes, and the hidden columns never leave your private file.

Can I hide formulas but show results?

Not in the same file. Use IMPORTRANGE to bring in only values, or copy and paste values only into the shared file.

Protect columns from being edited

  1. Select the columns.
  2. Right-click and choose View more cell actions > Protect range, or click Data > Protect sheets and ranges.
  3. Add a description and click Set permissions.
  4. Choose Restrict who can edit this range > Only you or Custom, and click Done.

Editors can still see the protected columns. They just can’t change them.

Hide columns for a tidier view

If privacy isn’t the goal and you just want to declutter, select the columns, right-click, and choose Hide columns. To hide a whole tab, right-click the tab and choose Hide sheet. Use Filter views from the Data menu to give each person their own view without changing what others see.

Hide a whole tab from specific users

The same limits apply to tabs. A hidden sheet can be unhidden by editors and is visible to anyone who downloads the file. To keep a tab private, move it into its own spreadsheet and share that file only with the people who need it.

Before you share a sensitive spreadsheet

  • Turn off downloading, printing and copying for viewers and commenters in the share settings gear.
  • Check File > Version history, which editors can use to see older data you’ve since removed.
  • Remove sensitive data entirely from shared files rather than relying on hiding.

Related: hide a column in Google Sheets.

Related: hide and unhide a sheet in Google Sheets.