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? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-33.png)
Go to protection, and uncheck the Locked box.
![How To Lock Excel Formulas To Protect Them? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-34.png)
Press F5 to quickly get the Go To window.
![How To Lock Excel Formulas To Protect Them? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-35.png)
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?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-36.png)
![How To Lock Excel Formulas To Protect Them? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-37.png)
Now the all cells containing formulas are selected.
Go to Review and click on Protect Sheet.
![How To Lock Excel Formulas To Protect Them? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-38.png)
Enter the password and uncheck Select locked cells.
![How To Lock Excel Formulas To Protect Them? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-39.png)
Confirm your password.
![How To Lock Excel Formulas To Protect Them? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-40.png)
![How To Lock Excel Formulas To Protect Them? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-41.png)
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? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-42.png)
You can edit the sheet only after clicking on Unprotect Sheet first.
![How To Lock Excel Formulas To Protect Them? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-43.png)
Finally, wish you Merry Christmas, and enjoy your happy life.
![How To Lock Excel Formulas To Protect Them? How To Lock Excel Formulas To Protect Them?](https://www.myofficetricks.com/wp-content/uploads/2021/12/image-44.png)
Leave a Reply