How to Unprotect an Excel Spreadsheet

What this does

Unprotecting a sheet removes the editing restrictions that Protect Sheet imposed, so every cell can be changed again. The control sits on the Review tab: if the sheet was protected without a password, one click of Unprotect Sheet frees it; if a password was set, Excel asks for it first. Removing protection is purely about re-enabling edits — it has nothing to do with opening an encrypted file, which needs the file password instead. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “unprotect an excel spreadsheet”. Start on a copy or a tiny sample, keep the affected sheet visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a workspace setting that makes a big sheet comfortable to navigate, but the practical win is that someone else can open the file and understand what happened without asking you.

A worked example

A budget sheet shows "cell is protected" whenever you try to type. Go to the Review tab and click Unprotect Sheet. If a password was set, a box appears — enter it, click OK, and the protection lifts; the button now reads Protect Sheet again and every cell accepts input. If no password was ever set, the single click is all it takes and no prompt appears. You unprotect a sheet whenever locked cells are blocking a legitimate edit — updating a template someone secured, correcting a figure in a protected report, or reworking a form. It is the deliberate step that hands editing control back, the exact reverse of Protect Sheet. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. If you take one thing from this page on “unprotect an excel spreadsheet”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.

Common mistakes

• Trying to unprotect without the password: there is no legitimate built-in bypass, so you genuinely need the password that was set.
• Confusing a protected sheet with an encrypted file — a file that will not open needs its open-password, not Unprotect Sheet.
• Unprotecting the wrong sheet in a multi-tab workbook; each sheet is protected and unprotected separately.
• Forgetting that workbook structure protection (locked tabs) is removed via Unprotect Workbook, a different button on the same tab.

Frequently asked questions