Hide Formulas in a Worksheet

If you are using formulas in an Excel worksheet, you may not want to display these formulas to users such as clients or potential clients.

Excel provides a way to hide the formulas in a worksheet so they are not displayed in the Formula bar when a cell is selected. The formula result is displayed in the cell, but the user is prevented from seeing what calculation is being performed.

Hiding the formulas in a worksheet requires 2 stages. First we need to specify that we would like the cell contents to be hidden. Then we protect the worksheet to enforce these settings.

Set the Cell Properties to Hidden

Every cell of an Excel worksheet has two properties that are applied. These are locked and hidden. By default every cell is locked but not hidden.

1. Select the cells containing the formulas you want to hide.

2. Press Ctrl + 1 on the keyboard, or click the Format button and then Format Cells on the Home tab of the Ribbon.

Opening the Format Cells dialog box
Opening the Format Cells dialog box

3. Click the Protection tab in the dialog box.

4. Check the Hidden box. The Locked box should already be checked by default. If not check this box too to prevent users from editing the cell.

Select hidden to hide the formulas in selected cells
Select hidden to hide the formulas in selected cells

5. Click Ok.

Protect the Worksheet

Hiding the content of a cell has no effect until the worksheet is protected. Protecting a worksheet enforces these changes in the same way that a key locks a door. The lock on the door has no effect until the key is turned.

1. Click the Review tab on the Ribbon.

2. Click the Protect Sheet button in the Changes group.

3. Enter a password. This password will be required to unprotect the sheet at a later date.

Protect the worksheet to enforce the hidden formulas
Protect the worksheet to enforce the hidden formulas

4. Check the boxes of any features you may want your users to be able to use. By default they may only select cells.

5. Click Ok

More by this Author

  • Simulate a Cup Draw using Excel
    0

    Microsoft Excel can do some amazing things. I like to attempt little projects testing what Excel can do. I was asked the other day to simulate a cup draw using Excel and this is the result. This article will give you...

  • Sort Pictures in an Excel List
    0

    If you are using pictures in your Excel spreadsheet you may be having some difficulty with sorting the pictures along with the other data in the list. The good news is that you can sort pictures in an Excel list just...

  • Basset Hound Puppy – What Equipment Do I Need?
    0

    Thinking of buying a basset hound puppy? Wondering what equipment you need in the house ready for the arrival of your new pet. This article will identify the 10 items you cannot be without to welcome home and care for a...


Comments

No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working