Protect a sheet or range
To protect a sheet or range, use Google Sheets on a computer.
Hide sheets from view
You can hide sheets that are old or are placeholders for calculations used by other sheets.
- Hiding a sheet is not the same as protecting a sheet.
- All spreadsheet editors can unhide and view these sheets for convenience.
- Spreadsheet viewers can still access content in hidden sheets. For example, if a viewer makes a copy of the spreadsheet, the sheets remain hidden, but they can unhide the sheets.
To hide or unhide a sheet, use Google Sheets on a computer.
Edit sheets
Copy a sheet
To copy a sheet within a spreadsheet:
- Open a spreadsheet in the Google Sheets app.
- On the sheet tab, tap the Down arrow
.
- Tap Duplicate. A duplicate sheet will appear in a new tab next to the original sheet. It's named "Copy of Sheet."
.Reorder sheets
To change the order of the sheets in a spreadsheet, drag a sheet tab until it is in the order you want.
Rename a sheet
To change the name of a sheet in a spreadsheet:
- Open a spreadsheet in the Google Sheets app.
- On the sheet tab, tap the Down arrow
- Tap Rename.
- Enter the new name, then tap OK.
Add color to a sheet tab
To add a color to your sheet tabs, use Google Sheets on a computer.
Delete a sheet
- Open a spreadsheet in the Google Sheets app.
- On the sheet tab, tap the Down arrow
- Tap Delete.
- Tap OK.