Hide Formulas In Protected Worksheet
I am sure that there are some projects where we did lots of research to create complex formulas, calculation and we do not want to show those amazing tricks which we created by ourselves but people can read your formulas in “Formula Bar” even if you have protected the sheet
Though you can hide Formula Bar but still you can hide formulas without hiding the Formula Bar:
Select the Cells, Range which is formula driven cells/range.
Right Click on the Selected Ranges and click on Format Cells
Go to Protect Tab and Check the box “Hidden” and click “Ok”. It will hide the formulas
Now when you protect the worksheet, it will hide all the formulas where you have ticked this box