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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help