Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
I want to know how to hide the formula bar in a particular file.. I have one file that has formula in some of the cells,, i don't want any-one to know the formula..
choose the cell which you need to hide its formula
click right click
choose Format Cells
go to Protection tap
then tap on hidden option
then OK
choose from the top the REVEIW tap
then choose sheet protection
put a passward
then you will have ahidden formula which couldn't access by others
Good luck
Mhd eid
Right-click and then select "Format Cells" from the popup menu. When the Format Cells window appears, select the Protection tab.
Select the cells which have formulas, click on right click, go to format cells, go to protection, click on hidden.
Now go to home, you can see format in the top, go to format, select protect sheet and give password.
Click on Cell Bar in Home Tab, Than Format Than Format Cells and Click Protaction Cells. Check Hidden Box and Press OK. You are done.
Dear Friend
Your required solution is to Protect the cell then no one can select the cell and even with formula Bar visible he cannot check your formula.
If you need any further help then Please contact me at
