Duplicate, Move, and Hide Sheets

How to Duplicate, Move, and Hide Sheets in Google Sheets

Duplicate, Move, and Hide Sheets

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

Duplicate a Sheet

  1. Click the sheet tab you want to duplicate.
  2. Click the sheet tab's arrow.
  3. Select Duplicate.
    Duplicate, Move, and Hide Sheets.
  4. (Optional) Rename the duplicate sheet.
    Duplicate, Move, and Hide Sheets.

The selected sheet is moved or duplicated.

Move a Sheet

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

  1. Click and drag the sheet to the desired location.
    Duplicate, Move, and Hide Sheets.

The sheet is moved to a new location.

Hide a Sheet

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.
    Duplicate, Move, and Hide Sheets.

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.

Unhide a 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.
    Duplicate, Move, and Hide Sheets.

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

The sheet is unhidden.

FREE Quick Reference

Click to Download