Sheet protection in Excel - Step-by-Step Guide

Introduction

Sheet protection helps you stop others from changing your worksheet by locking cells or the whole sheet. It is useful when you want to keep your data safe and avoid accidental edits.

When you share a budget sheet and want to prevent others from changing formulas.

When you create a form in Excel and want users to fill only specific cells.

When you prepare a report and want to keep the layout and data intact.

When you want to stop accidental deletion of important data in your worksheet.

When you want to allow users to sort or filter data but not edit the content.

Steps

Step 1: Select the cells you want users to be able to edit

- Worksheet area

Selected cells are highlighted

💡 By default, all cells are locked, so unlock the cells you want editable before protecting the sheet

Step 2: Right-click the selected cells and choose Format Cells

- Context menu

Format Cells dialog box opens

Step 3: Click the Protection tab and uncheck Locked

- Format Cells dialog box

Selected cells are unlocked and can be edited after sheet protection

💡 Unlock only the cells users should change

Step 4: Click OK to close the Format Cells dialog

- Format Cells dialog box

Dialog closes and changes are saved

Step 5: Go to the Review tab and click Protect Sheet

- Ribbon, Review tab

Protect Sheet dialog box opens

Step 6: Type a password if you want to require one to unprotect the sheet

- Protect Sheet dialog box

Password is set (optional)

💡 Remember your password; if lost, you cannot unprotect the sheet

Step 7: Check or uncheck permissions like Select locked cells or Format columns

- Protect Sheet dialog box

Permissions are set for what users can do on the protected sheet

Step 8: Click OK to apply sheet protection

- Protect Sheet dialog box

Sheet is protected; locked cells cannot be edited

Before vs After

Before

All cells are editable; formulas and data can be changed accidentally

After

Only unlocked cells can be edited; locked cells and sheet structure are protected from changes

Settings Reference

Locked

📍 Format Cells dialog box > Protection tab

Determines if a cell is locked when the sheet is protected

Default: Checked

Password to unprotect sheet

📍 Review tab > Protect Sheet dialog box

Prevents others from unprotecting the sheet without the password

Default: Blank (no password)

Allow all users of this worksheet to:

📍 Review tab > Protect Sheet dialog box

Controls what users can do on the protected sheet

Default: Select unlocked cells checked, others unchecked

Common Mistakes

Not unlocking cells before protecting the sheet

All cells remain locked and users cannot edit any cell

Unlock the cells you want users to edit by unchecking Locked in Format Cells before protecting the sheet

Forgetting the password set for sheet protection

You cannot unprotect the sheet without the password and may lose access to editing

Store the password safely or leave it blank if you do not want to use a password

Assuming protection stops all changes including workbook structure

Sheet protection only protects the current sheet; workbook structure protection is separate

Use Protect Workbook feature to protect workbook structure if needed

Summary

Sheet protection locks cells to prevent unwanted changes.

Unlock cells first to allow editing after protection.

Use a password to control who can unprotect the sheet.