• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office
Home » Windows 10 » How to Hide Formulas in Excel

How to Hide Formulas in Excel

By: Waseem Patwegar

Hiding Formulas in Excel is an effective way to prevent the formulas from being erased, modified or altered in any way. In this tutorial we are going to provide you the steps to hide formulas in Excel.

Hide Formulas in Excel

Hide Formulas in Excel

As you must have noticed, when you click on a Cell, the formula used in that particular Cell is displayed in the formula bar. This setup in Microsoft Excel makes it easy to view, edit or modify formulas as required.

However, some users like to hide Formulas in Excel, in order to prevent them from being accidentally modified or for security, confidentiality and propriety reasons.

When you hide Formulas in Excel, other users will no longer be able to view the formula, even if they click on the Cell containing the formula is selected.

Hiding Formulas has no adverse impact on calculation or performance of the spreadsheet, it behaves exactly the same way as an Unprotected sheet.

If any user inputs new values in other cells that the formula makes use of, calculations will be performed using the formula and you will see new results when you hit the enter key.

Steps to Hide Formulas in Excel

Hiding Formulas in Excel is a two-step process. You first need to first makes the cells containing formulas hidden and also protect the worksheet. Hiding formulas won’t go into effect until you actually protect the worksheet

In this let us assume that you have worksheet containing formulas in Column C and you do not want these formulas to be seen by others.

To hide formulas, select Cells containing Formulas > right-click and then click on Format Cells option in the menu that appears.

Format Cells option in Excel

On the Format Cells screen, click on the Protection tab > check the little box next to Hidden and click on OK.

Hide Cells in Excel

As you can see from notes mentioned in above image, hiding cells containing formulas has no impact, until you protect the worksheet.

To protect the Worksheet, click on the Review Tab and then click on Protect Sheet option in “Changes” section.

Protect Worksheet Option in Excel

On the Protect sheet screen, you can enter a Password to prevent people from un-hiding the formulas and click on OK or choose not to use a password and just click on OK.

Enter Password to Protect Worksheet

Depending on your requirements, you can grant privileges to other users to Format Cells, Insert Rows, Delete Columns and perform other actions.

Allow All Users to Perform Selected Actions in Worksheet

Once the sheet is protected, you won’t be able to view the formulas, even if you click on the cells containing formulas or click on Show Formulas option in the top menu bar.

As mentioned above, hiding formulas has no adverse impact on the functioning of the worksheet. Users will be able to change values in other cells and new results will be generated, whenever the input values are changed.

Related
  • How to Insert Checkbox in Excel
  • How to Start New Line in Excel Cell

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar



Recent Posts

  • Fix: Cannot Authorize Computer On iTunes Error
  • Your SIM Sent a Text Message Notification on iPhone
  • Fix: iPhone Camera Black Screen Problem
  • How to Clear Your Activity History In Windows 11
  • How to Find WiFi Password in Windows 11




About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved