Forum Discussion

Ronald1969's avatar
Ronald1969
Brass Contributor
Feb 10, 2020
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.
Formulas and Functions
  • Abiola1's avatar
    Abiola1
    Feb 10, 2020
    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.
Abiola1's avatar
Abiola1
MVP
Feb 10, 2020
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.