Insert and Hide Functions and Formulas Part 4 | TechTricksGh
To hide the Expenses function, right-click on it and select format cell from the list. Now navigate to the protection button and make sure that lock and hide are ticked and hit okay.
Do the same for the balance button, right-click on it and select format cell from the list. Now navigate to the protection button and make sure that lock and hide are ticked and hit okay.
It is now time to protect the worksheet, to do this go to the Review tab, and hit protect worksheet from the protect group. From the dialogue box, enter your password, maintain the current settings and hit okay. Re-enter your password again and hit okay.
After adding protection to the worksheet, the detailed amount is visible and editable, the same implies the Budget amount but the expense’s function and the balance formula are hidden and not editable.
That's it. TechTricksGh, don't forget to Share, Like, Subscribe and hit the bell notification for more tutorials.