How to Protect a Sheet in Excel: Simple Steps to Secure Your Data

To protect a sheet in Excel, go to the Review tab and click Protect Sheet. You can set a password to prevent others from editing locked cells or changing the sheet structure.

Syntax

The basic way to protect a sheet in Excel is through the Protect Sheet feature found under the Review tab. You can optionally add a password to restrict editing.

In VBA (Excel's programming language), the syntax is:

Worksheet.Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)

Here, Password is a string to lock the sheet, and other options control what users can do on the protected sheet.

vba

Worksheet.Protect Password:="mypassword", Contents:=True, AllowSorting:=True

Example

This example shows how to protect a sheet manually and with VBA code.

Manual steps:

• Click the Review tab.
• Click Protect Sheet.
• Enter a password (optional) and select permissions.
• Click OK.

VBA example: This code protects the active sheet with a password and allows sorting.

vba

Sub ProtectMySheet()
    ActiveSheet.Protect Password:="mypassword", Contents:=True, AllowSorting:=True
End Sub

Output

The active sheet is now protected with password 'mypassword'. Users can sort but cannot edit locked cells.

Common Pitfalls

Common mistakes when protecting sheets include:

• Not setting a password, which allows anyone to unprotect the sheet easily.
• Forgetting to unlock cells you want users to edit before protecting the sheet.
• Using a password you might forget, which can lock you out of your own sheet.
• Assuming protection stops all changes; it mainly prevents editing locked cells and structure changes.

Wrong way: Protecting without unlocking editable cells.

Right way: Unlock cells first, then protect the sheet.

vba

Range("A1:A10").Locked = False
ActiveSheet.Protect Password:="mypassword"

Quick Reference

Action	Location/Command	Notes
Protect Sheet	Review tab > Protect Sheet	Set password and permissions
Unprotect Sheet	Review tab > Unprotect Sheet	Enter password if set
Unlock Cells	Home tab > Format > Lock Cell (uncheck)	Unlock before protecting to allow editing
VBA Protect	Worksheet.Protect method	Use for automation with options
VBA Unprotect	Worksheet.Unprotect method	Remove protection with password

Key Takeaways

Use the Review tab's Protect Sheet feature to secure your Excel sheet easily.

Set a password to prevent unauthorized changes and remember it to avoid lockout.

Unlock cells you want users to edit before protecting the sheet.

Sheet protection mainly prevents editing locked cells and structural changes, not all changes.

You can automate protection using VBA with flexible options.