Protect a sheet and encrypt with a password
Updated November 13, 2026
Protect a sheet
- Choose Review › Protect sheet.
- Pick what people may still do, such as select cells or format them, and add a password if you like. Then choose OK.
- Cells are locked by default. To leave some open for typing, select them first, choose Format › Format Cells…, and on Protection turn off Locked.
Choose Review › Unprotect sheet to stop protecting it.
Protect the workbook
- Review › Protect workbook stops sheets being added, deleted, renamed, moved or hidden.
Encrypt with a password
- Choose File › Encrypt with Password….
- Type a password and type it again, then save. The file needs the password to open, in Cloud Sheets and in Excel.
There’s no way to open an encrypted file without its password, so keep it somewhere safe.