Protect, hide, and edit sheets
If you don’t want people to change the content in a spreadsheet, you can protect it. This shouldn’t be used as a security measure. People can print, copy, paste, and import and export copies of a protected spreadsheet. Only share spreadsheets with people you trust.
Protect a range or sheet
Who can protect a range or sheet
Edit a copy of a protected sheet
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.
- Spreadsheet viewers can’t see hidden sheets. If someone makes a copy of the spreadsheet, the sheets will stay hidden, but they’ll be able to unhide the sheets.
Hide or unhide a sheet
Import and export spreadsheets with hidden sheets
Edit sheets
Copy a sheet
Reorder sheets
Rename a sheet
Add color to a sheet tab
Delete a sheet
Comments
Post a Comment