Help Menu

Quick Protect

Quick Protect allows you to protect all the worksheets in a workbook in a single pass.

Form Fields

  • Password: Optional password to secure the sheet protection. (Note: Spreadspeed does not save the password. It uses the built-in password protection mechanism provided by Excel.)
  • Hide password characters: Determines whether the password characters are displayed as you type them.
  • Apply to: All worksheets plus workbook structure [1] or just the active worksheet.
  • Unlock cells with these styles: After protection, check cell types can be edited, and all other cells are locked. These feature leverages built-in and custom styles to determine whether cells are unlocked.

[1] Workbook structure affects the order of the sheet tabs, sheet names, and whether sheets can be added, deleted, or hidden and unhidden.