Hide Formula in Microsoft Excel sheets

Using the formula in Excel can make your day-to-day tasks easier. Excel has formulas for almost all the operations. Having said that don’t you it is desirable to hide formulae if you are sharing your Excel spreadsheet with your colleagues or boss if you do not want to give them a clue about tricks you have used in getting the work done on time.  Well, all the formulas and the calculation work can be hidden from the viewers if you hide your formulas in Excel 2013/2016 sheet. How do you do it? Let’s see!

Hide Formula in Excel

The formulas are displayed in the formula bar as shown in the screen-shot below. Alternatively, to display the formula, you can click ‘Show Formulas’ in the Formula Auditing section of the Formulas tab.

Hide Formula in Excel 2013

If you don’t want the formulas visible to users viewing your spreadsheet, you can hide them and protect the sheet. To do this, select the cells whose formulas you want to hide.

Next, move to ‘Home’ tab. Look for the Cells section to the Right. From this section, choose Format and select Format Cells from the drop-down menu.

format cells

Instantly, the Format Cells dialog box should pop up on your computer screen. When this happens, switch to ‘Protection’ tab. There, select the Hidden check box and Hit ‘OK’.

Format hidden

The final step is to protect your Excel Worksheet to finish hiding the formulas. Click Format in the Cells section of the Home tab again. Now, select Protect Sheet from the drop-down menu.

protect sheet

When presented with the dialog box, make sure contents of locked cells and the Protect worksheet check box is selected. You will be required to enter a password in the Password field.

password

Enter your password again in the Reenter password to proceed edit box on the Confirm Password dialog box and click OK.

At any stage, should you feel to unprotect the sheet and show the formulas again, select unprotect sheet option and enter the saved password in Unprotect Sheet password box.

In the Allow all users of this worksheet to list box, select the check boxes for the tasks you want to allow the users to perform. Click OK.

Now see how you van make the best use of Name Box in Excel.

Posted by on , in Category Office with Tags
The author Hemant Saxena is a post-graduate in bio-technology and has an immense interest in following Windows, Office and other technology developments. Quiet by nature, he is an avid Lacrosse player. Creating a System Restore Point first before installing a new software, and being careful about any third-party offers while installing freeware is recommended.