Sometimes you really don’t want your hard working Excel formulas to be viewed, you maybe don’t want your colleagues to know your Excel secrets or it maybe you don’t clients to know how you have calculated costs as they are based on a predicted sales figure?. Whatever the reason it’s really easy to hide your formulas, why would I show you this?….
Of course I am here here to help YOU Excel at Excel so, of course I am going to show this secret. So let’s get going!
I am assuming here that you know how to set up your worksheets to allow selective locking of cells, if you are unsure then check out this post on Protecting My Data In Excel.
Hiding the formulas on an Excel worksheet is similar to protecting your Excel sheets with a password, or being selective about which cells, rows or columns you protect. Ok assuming you have unlocked all or the cells you want to hide….
1. Right click on the cell/s or highlight all of the worksheet
2. Format cells
3. Select Hidden
4. Click Ok
5. Review Tab
7. Hide sheets using a password
See the difference that this makes to your worksheets, both Sales peoples bonus calculations can be seen in the first screenshot..
But in the second Toni’s bonus calculation can be clearly seen, but Amy’s cannot. Isn’t that awesome?
When you take a closer look maybe we don’t want to show Toni’s’ as she is on waaaay more of a bonus than Amy!!! Look at the first screenshot and calculations….