Protect a sheet and encrypt with a password

Updated November 13, 2026

Protect a sheet

  1. Choose Review › Protect sheet.
  2. Pick what people may still do, such as select cells or format them, and add a password if you like. Then choose OK.
  3. 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

  1. Choose File › Encrypt with Password….
  2. 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.

Was this article helpful?