How to Remove Protection and Unhide Formulas in Excel

Step 1: Open the spreadsheet

Step 2: Unprotect the cells

1. Go to the “Review” section. Click on “Unprotect Sheet” option.

2. After completing the above step the below dialog box will open.

3. Enter the password you provided during protecting the cells.

Now the cells are unprotected.

Step 3: Unhide the formulas

1. Press Ctrl + A to select all the cells of the sheet.

2. Right click and select the “Format cells” option.

3. On the popped-up dialog box, go to “Protection” tab. Uncheck the “Locked” and “Hidden” option to unhide the formulas. Click on “Ok”.

Now the formulas are unhidden and unlocked.

Fed up with unintentionally messing up your Excel formulas and causing chaos in your meticulously designed spreadsheets? Don’t worry! Mastering the skill of locking formulas is your solution. In this brief tutorial, we’ll delve into the techniques to protect your calculations from unintended alterations, ensuring that your Excel wizardry remains undisturbed. Let’s jump into the straightforward practice of locking formulas and ensuring the security of your data sorcery.

In this article, we will discuss how to lock and protect the formulas within the Excel sheet along with an example.