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

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

متابعة

How to hide your formula from other users ?

You make a formula and need nobody to see it.

user-image
تم إضافة السؤال من قبل Mohamed Sabry , Document Control Manager , Canal Sugar
تاريخ النشر: 2013/05/15
Mehdi Terrak
من قبل Mehdi Terrak , JR Brand manager , DANONE

Hi mohamed, There is different way to hide a formula in excel.
Step I : Select the cell => right click=> Cell-format=> Protection=>Choose hidden=> Press ok.
Step II : Click on review onglet =>Protect sheet =>Choose a password =>Click ok.
Now your formula is hidden.
But you must know that there is different programs that can bypass this security.
:) Good luck

Mike Emerson Pasaron
من قبل Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

Select the cell or cells, press Ctrl+1 or format cells, go to PROTECTION TAB and check HIDDEN and click ok.
Then protect your worksheet.

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