Hiding formulas in excel is a thing that most of the excel users would love to know. Actually it is quite useful in the cases where you want to share an excel sheet with other people and don’t want to reveal a particular formula that you have used for any calculations. So it is always a wise option to hide your formulas before sharing your excel sheet with others.
Hiding formulas in excel is an easy task very similar to protecting cells in an excel sheet. The basic idea behind hiding formulas in excel is that first you have to change the format of the cell to hidden and then lock that cell, so that no one can change the contents.
Steps to Hide Formula in Excel:
- To hide formula in excel first of all you have to select the cell, right click on the cell and select the option “Format cells”.
- Now a “Custom List” window will open, navigate to the “Protection” Tab and check the “Hidden” option and click “Ok”.
- After this navigate to the “Review” tab in excel, select the “Protect sheet option”.
- In the Protect sheet window, check keep the default check boxes checked as shown in the image, enter the password and click “Ok”
- Now, the formulas in the selected cells will be hidden i.e. they won’t show up in the edit bar.
Steps to Unhide a Formula in Excel:
Now if you want to make some changes to the formula again you need to unprotect the sheet.
- To unhide the formulas simply navigate to the “review” tab and select the option “Unprotect sheet”.
- Now a window will pop out, asking for your password. Here you need to enter the same password that you used to hide the cells.
- After entering the password click “Ok” and your cells will get un protected and you can make the desired changes to the cells.
?ed the ABOVE POST, THEN GO A STEP FURTHER AND SHARE IT WITH YOUR FRIENDS!!
Article by Ankit
Ankit is the founder of Geek Revealed. He is tech Geek who loves to sit in front of his square headed girlfriend all day long. :D You can find Ankit on FaceBook or Google Plus
Geek Revealed is the brainchild of Ankit Kaul. Ankit is an Optimist by nature, Software Engineer by profession and an Indian by race. We at Geek Revealed help you to take maximum advantage of software and web tools and thereby boost you to reveal your inner geek. You can read more about us
Comments on this entry are closed.