Forum Discussion
Solved
Lock and Hide formula
Can someone please guide me to hide formula from showing in formula bar and lock it so that no changes can be done in the formula.
- 1. Select the cells for which you to want to hide the formulas.
2. Right-click the cell (or cells) and choose Format Cells.
3. In the Format Cells dialog box, click the Protection tab.
4. Check the Hidden box.
4 Replies
- ...
1. In the Protect group of the Review tab, click on Protect Sheet.
2. Uncheck Select locked cells box
3. Click OK
The formula will be hidden and the cells locked
Hope this answers your question- Thank you and God Bless,
Ronald Pinto- You're welcome... God bless you too
- 1. Select the cells for which you to want to hide the formulas.
2. Right-click the cell (or cells) and choose Format Cells.
3. In the Format Cells dialog box, click the Protection tab.
4. Check the Hidden box.
