Happy Friday Excellers, something a little different for today’s #formulafriday blog. Instead of showing our Excel formulas I want to show you how to HIDE your Excel formulas.
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 want clients to know how you have calculated costs as they are based on a predicted sales figure?.
So Let’s Get Hiding Those Formulas!
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. First you need to UNLOCK the cells where you want to hide your Formulas……
- Select your cells
- Right Click on your cells
- Protection Tab| remove locked tick
- Right click on the cell/s or highlight all of the worksheet
- Format cells
- Select Hidden
- Click Ok
- Review Tab
- Protect Sheet
- 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..none of the formulas are hidden.
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….
If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.
If you want to see all of the blog posts in the Formula Friday series you can do so by clicking on the link below.