How to hide a sheet in Google sheets from other users

How to hide a sheet in Google sheets from other users

If an existing sheet contains information you need in a new sheet, you can duplicate it and save time with data entry.

The selected sheet is moved or duplicated.

It's easy to change the order of sheets in a spreadsheet.

  1. Click and drag the sheet to the desired location.
    How to hide a sheet in Google sheets from other users

The sheet is moved to a new location.

When you have a spreadsheet that's shared with other people, you may want to hide certain sheets so information isn't visible.

  1. Click the sheet tab you want to hide.
  2. Click the sheet tab's arrow.
  3. Select Hide sheet.
    How to hide a sheet in Google sheets from other users

You can also right-click a sheet tab and select Hide sheet from the menu.

Sheets hides the sheet. Keep in mind, this doesn't protect the spreadsheet. Anyone with access to the file can easily unhide the sheet.

If you no longer want the sheet hidden, you can make it visible once again.

  1. Click View on the menu bar.
  2. Select Hidden sheets from the context menu.
  3. Select the sheet you want to unhide.
    How to hide a sheet in Google sheets from other users

You can also right-click any sheet tab and select Unhide from the menu.

The sheet is unhidden.