ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

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..

user-image
تم إضافة السؤال من قبل Moin Mohamed , Sr. Purchasing Analyst, , Al-Khafji Joint Operation - KJO
تاريخ النشر: 2014/02/20
ﻣﺤﻤﺪ ﻋﻴﺪ ﺍﻟﺤﺎﻳﻚ
من قبل ﻣﺤﻤﺪ ﻋﻴﺪ ﺍﻟﺤﺎﻳﻚ , Accountant , Sadaka Trading company

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

 

 

Younus Mohammed
من قبل Younus Mohammed , Administrative Officer Cum Accountant , RURAL INTEGRATED AND SOCIAL EDUCATION SOCIETY (RISES)

Right-click and then select "Format Cells" from the popup menu. When the Format Cells window appears, select the Protection tab.

krushnasinh chavda
من قبل krushnasinh chavda , General Accountant , Pixel Digital Systems LLC - UAE

 

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.

 

Mohemad Asharaf Vahora
من قبل Mohemad Asharaf Vahora , Accountant , Ingie Etoile LLC

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.

Kashif Sherazi
من قبل Kashif Sherazi , Divisional Finance Manager , Almarai

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

المزيد من الأسئلة المماثلة