Excel: How To Hide Formulas from Other Users
Contributed by Rob Rogers 
Tagged: Microsoft Excel To prevent other users from seeing or modifying your formulas, format the relevant cells as hidden and then protect the worksheet or worksheets. To do this:
1. Select the cell or range of cells that contain the formulas.
2. Choose Format – Cells (or use Ctrl+1 on the keyboard) to display the Format Cells dialog box.
3. Select the Hidden and Locked check boxes on the Protection tab.
4. Click the OK.
5. Choose Tools – Protection – Protect Sheet to display the Protect Sheet dialog box.
6. Make sure that the Protect Worksheet and Contents of Locked Cells check box is selected.
7. Type the password for protecting the worksheet in the Password to Unprotect Sheet text box.
8. Click the OK. Excel will display the Confirm Password dialog box.
9. Type the password again and then click OK.
You may also like -
Office 2010: Set or Remove a Document's Password
Excel 2007: How to Clear the Values while Keeping Formulas
Excel 2007: Show Formulas to Verify Your Equations
Excel 2007: Where Did They Hide My Favorite Commands?
Microsoft Excel: How to Hide Tabs
Excel: How To Create a Conditional Format
How Can I Hide my Favorites in YouTube?
Excel 2007: How to View Twitter Updates (Tweets) in a Worksheet
Anil said on January 14, 2010
Hi,
I tried this option and it is not working in Excel 2007.
The formula is still visible even after using this option “Select the Hidden and Locked check boxes on the Protection tab.”.
Anonymous said on February 15, 2010
Hi It was working well.
I have tested the same…
RIPON SARKAR said on February 18, 2010
i have followed the process to hide formula in excel but i want to carry on the work in sheet without protection by not viewing the formula in the cell in which i have given formula
Anonymous said on February 24, 2010
formula is working. It is very useful for me for calculating formulas
Anonymous said on March 4, 2010
Hi Ripon Sarkar ,
Read your problem, just a quick question did you sort it because i want to know how to do it.
Mark
Anonymous said on April 17, 2010
1. Select the cell or range of cells that contain the formulas.2. Choose Format – Cells (or use Ctrl+1 on the keyboard) to display the Format Cells dialog box.2A, Select the font tab & fomat all cell range as white then3. Select the Hidden and Locked check boxes on the Protection tab.4. Click the OK.5. Choose Tools – Protection – Protect Sheet to display the Protect Sheet dialog box.6. Make sure that the Protect Worksheet and Contents of Locked Cells check box is selected.7. Type the password for protecting the worksheet in the Password to Unprotect Sheet text box.8. Click the OK. Excel will display the Confirm Password dialog box.9. Type the password again and then click OK.
Anil said on April 18, 2010
This is fine but want to know if at all there is any option where we can hide the formula and the sheet can be used without protecting it. Here in this case the sheet is protected and no one can use it unless it is unprotected.
Please advise……!
Anil said on April 21, 2010
Anil,
The premise of the attributes “locked” & “Hidden” are only effective if the worksheet is protected. You can have individual attributes or both checked on & off.
With the “hidden” checked and “locked” unchecked, you can protect the worksheet which results in the formula being hidden but if you wish you can edit it, though you cant see what you’re editing.
The “protect sheet” icon is located on the “Review” tab in Office 2007.
Rahul_dyalbagh said on June 26, 2010
hi its rahul i wanna know how i can hide my formula from othe user by without protecting sheet.
Anu said on December 8, 2010
Nice one … thanks very much…
Anu
yubraj said on December 21, 2010
How to hide all sheet in excel and how to hide formula for other user? plz reply with good answer.. Thanks.
Parcel_14 said on January 26, 2011
it working well. Thanks
Chandra Mouli said on March 10, 2011
Open the work book and use shortcut ALT+F11, click one sheet and go to the properties, it will reflects in the top of the menu(Short cut F4), in the properties, the last colomn will be the Visible, beside the visible select the dropdown as 2(very protect) and save. the work sheet will be hidden from the work book.
Chandra Mouli said on March 10, 2011
we can hide the formula from the work sheet, but after hiding the formula i am unable to edit the entire work sheet.
Hashim Bd said on March 25, 2011
Hi,
Its working, but after hiding the formula i can not edit my data. Plz help me hiding only formula (data should be editable)
Thanks
Hashim
Karthikeyan said on April 5, 2011
You can do so by selecting the locked cells off and only leaving hidden option enabled. this way you will be able to edit ur cells and the formulas won’t be visible also..!!