Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Lock Excel Formulas To Protect Them?

Date:2021-12-25 Author:Sandra

Sometimes, we just want others to see the number, but couldn’t see how the number came from. There is a nice way that works.

Click on the green triangle to select the whole sheet. Then right-click and choose Format Cells in the list.

How To Lock Excel Formulas To Protect Them?

Go to protection, and uncheck the Locked box.

How To Lock Excel Formulas To Protect Them?

Press F5 to quickly get the Go To window.

How To Lock Excel Formulas To Protect Them?

Click on Special, then check Formulas in the window. Hit OK.

How To Lock Excel Formulas To Protect Them?
How To Lock Excel Formulas To Protect Them?

Now the all cells containing formulas are selected.

Go to Review and click on Protect Sheet.

How To Lock Excel Formulas To Protect Them?

Enter the password and uncheck Select locked cells.

How To Lock Excel Formulas To Protect Them?

Confirm your password.

How To Lock Excel Formulas To Protect Them?
How To Lock Excel Formulas To Protect Them?

You will notice that your cursor is unable to select any cells with formulas. This also means that the formulas cannot be seen.

How To Lock Excel Formulas To Protect Them?

You can edit the sheet only after clicking on Unprotect Sheet first.

How To Lock Excel Formulas To Protect Them?

Finally, wish you Merry Christmas, and enjoy your happy life.

How To Lock Excel Formulas To Protect Them?

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *