Protect, hide, and edit sheets

• If you own a spreadsheet: You can decide who can change ranges and sheets.
• If you can edit a spreadsheet: You can decide who can edit ranges and sheets but can’t take permissions away from owners.
• If you can view or comment on a spreadsheet: You won't be able to make any changes.

• If you can edit: You can make a copy of the protected sheet, copy the workbook, or upload a new version.
• If you have can view but not edit: You can make a copy of the spreadsheet.

To hide a sheet:

To unhide a sheet:

1. Click View Show [name]. If your spreadsheet doesn’t have any hidden sheets, this option will be grayed out.
2. Click the sheet that you no longer want hidden.
3. The spreadsheet will reappear.

Hidden sheets will stay hidden if you:

• Export the spreadsheet as a .pdf, .xls, or .ods file.
• Import the spreadsheet in .xls, .xlsx, or .ods format.
• Exporting the spreadsheet to html with the "/htmlview" parameter: If you include the page parameter (#gid=N) in the URL, the hidden sheet will show.
• Publish the spreadsheet.

You can copy a sheet in a spreadsheet. Copies can be made within the same spreadsheet or into a separate spreadsheet.

To copy a sheet to another spreadsheet:

1. On the sheet tab, click the Down arrow .
2. Click Copy to.
3. Choose the destination spreadsheet from the list.
4. Click Select.

To copy a sheet within a spreadsheet:

1. On the sheet tab, click the Down arrow .
2. Click Duplicate.
3. A duplicate sheet will appear in a new tab next to the original sheet.

To change the order of the sheets in a spreadsheet, click and drag a sheet tab until it is in the order you want.

To change the name of a sheet in a spreadsheet, double-click the text on the sheet tab and type in the new name.

Add a color to your sheet tabs to easily tell them apart.

1. On the sheet tab, click the Down arrow .
2. Click Change color.
3. Select a color.

1. Click the sheet you want to remove.
2. On the sheet tab, click the Down arrow .
3. Click Delete.
4. Click OK.