How to hide the formula bar in a particular Excel file??

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