Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to hide your formula from other users ?

You make a formula and need nobody to see it.

Microsoft Excel
user-image
Question added by Mohamed Sabry , Document Control Manager , Canal Sugar
Date Posted: 2013/05/15
Upvote (0) Views (12) Followers (0) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Mehdi Terrak
by 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
by 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.

Write Your Answer
More Questions Like This