Excel: Protecting Sheets and Workbooks from Accidental Edits

If you share Excel spreadsheets with others, you can protect them from accidental changes — locking specific cells, sheets, or the entire workbook. Protect a specific sheet (most common use): This prevents anyone from editing the sheet unless they know the password. 1. Go to the Review tab > Protect Sheet 2. Set a password (optional but recommended) 3. In the list, check what actions you want to allow users to do even while protected (e.g. "Select locked cells," "Sort," "Use AutoFilter") 4. Click OK and confirm the password Once protected, the sheet is locked. Users get an error if they try to edit a locked cell. Allow editing in specific cells only: Before protecting the sheet, unlock the cells you want people to be able to edit: 1. Select the cells that should remain editable 2. Right-click > Format Cells > Protection tab > uncheck "Locked" 3. Now protect the sheet (above steps) Result: Only the unlocked cells are editable — everything else is locked. Protect the workbook structure: This prevents users from adding, deleting, renaming, or moving sheets. Review > Protect Workbook > set a password > OK The sheet tabs can still be viewed but not reorganized or deleted. Password protect the entire file: For highly sensitive files, you can require a password to open the file at all. File > Info > Protect Workbook > Encrypt with Password > enter and confirm a password > Save the file. WARNING: If you forget this password, the file cannot be opened. Store it securely. Unprotecting: Review > Unprotect Sheet (or Unprotect Workbook) > enter the password. When to use this: - Shared templates where you want users to fill in data fields but not change formulas - Reports where others can view but not accidentally delete data - Forms where only specific fields should be editable Note: Excel password protection is not enterprise-grade encryption — it deters accidental changes but is not strong security. For truly sensitive data, use proper file access permissions.