How to lock Excel sheet to prevent edit?

Locking an Excel sheet is a great way to protect your formulas and formatting from accidental changes while still allowing people to view the data.

Here is the quickest way to do it, depending on whether you want to lock the entire sheet or leave specific cells editable.

Method 1 : Lock Excel Sheet

Option 1: Lock the Entire Sheet

If you want to freeze everything so nobody can change a single cell, follow these steps:

• Open your Excel workbook and go to the worksheet you want to lock.
• Click on the Review tab in the top ribbon.
• Click Protect Sheet.
• A dialog box will appear. You can enter an optional password (highly recommended if you want to prevent others from just unlocking it).
• Ensure the box "Protect worksheet and contents of locked cells" is checked.
• Click OK (and re-enter your password if you set one).

Option 2: Lock the Sheet but Keep Specific Cells Editable

If you are creating a form or a template where someone needs to type data into specific boxes (like entering a name or numbers) while the rest of the sheet stays locked, follow this method:

• Select the cells that you want people to be able to edit.
• Right-click the selected cells and choose Format Cells (or press Ctrl + 1).
• Go to the Protection tab in the window that pops up.
• Uncheck the Locked box, then click OK. (By default, Excel sets all cells to "Locked", but this setting does nothing until you actually protect the sheet).
• Now, go to the Review tab and click Protect Sheet.
• Set a password if desired, and click OK.

Result: The cells you unchecked will remain completely editable, but everything else on the sheet will be completely frozen.

How to Unlock It Later ?

If you need to make edits yourself later, just go back to the Review tab, click Unprotect Sheet, and enter your password.

Example

Here’s a simple real-site example (like quantity sheet, measurement sheet in Excel)

Example Sheet

Column A → Item (LOCKED)

Column B → Description (LOCKED)

Column C → Rate (LOCKED)

Column D → Quantity (EDITABLE)

Column E → Amount (Formula, LOCKED)

Step 1 :Select Editable Cells (Quantity Column)

• Select Column D (Quantity)
• Right-click and select Format Cells
• Go to Protection tab 
• Uncheck Locked
• Click OK, Now only this (D) column is editable

Step 2: Protect the Sheet

• Go to Review tab
• Click Protect Sheet
• Set a password 
• Keep only this checked :Select unlocked cells and then Click OK

Method 2 : Lock Workbook File 

• Click File and go toInfo
• Click Protect Workbook
• Choose Encrypt with Password
• Enter password then click OK, now no one can open the file without password.

What if I protect excel sheet but don't set password?

If you protect an Excel sheet without setting a password, the sheet is still technically protected, but there is no security.

Here is exactly what happens:

1. It acts as a safety guard against accidents

The main benefit of protecting a sheet without a password is preventing accidental typos, deletions, or formula overwrites by you or anyone else working in the file. If someone tries to type in a locked cell, Excel will still throw up the standard warning block:

"The cell or chart you're trying to change is on a protected sheet..."

2. Anyone can unlock it with one click

Because there is no password, anyone who wants to edit the sheet can simply go to the Review tab and click Unprotect Sheet. Excel will instantly lift the protection without asking for any verification.