• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Excel Tips / Hide Formulas in Excel

Hide Formulas in Excel

Your spreadsheet formulas are always shown in the Formula Bar of Excel. This makes it easy to view and edit the formulas of a spreadsheet. How do you hide formulas in Excel?

If you do not want others to be able to view the formulas. Hide formulas in the Formula Bar by setting them to hidden and applying worksheet protection.

Before you apply worksheet protection, you need to change the property of the cells that contain the formulas to hidden.

Format the Cells to Hide the Formulas

  1. Select the cells where you want to prevent the formulas from being displayed.
  2. Click the Dialog Box Launcher arrow in the corner of the Number group on the Home tab, or press Ctrl + 1.
Open the Format Cells dialog box
  1. Select the Protection tab.
  2. Check the Hidden box and click Ok.
Hide formulas in Excel by setting their property to hidden

Apply Protection to Hide Formulas in the Formula Bar

To hide formulas in excel, after selecting which formulas to be hidden, we need to enforce this rule by protecting the sheet.

  1. Click the Review tab on the Ribbon.
  2. Click the Protect Sheet button.
  3. The password is optional and its use depends on how restrictive you want to be. The list of checkboxes enables you to select what a user can or cannot do on this worksheet. Make the necessary changes and click Ok.
Protecting a sheet in Excel

Now when you select a cell containing a formula. It will not be visible in the Formula Bar anymore.

Watch the Video

Related Posts:

  • What You Need to Know About Dynamic Array Formulas in Excel
    What You Need to Know About Dynamic Array Formulas in Excel
  • Excel FILTER Function – The Best Function in Excel
    Excel FILTER Function – The Best Function in Excel
  • Excel VLOOKUP Trick - No More Counting Columns
    Excel VLOOKUP Trick - No More Counting Columns
  • Entering Fractions in Excel
    Entering Fractions in Excel

Reader Interactions

Comments

  1. Stephen Oram says

    10 October 2017 at 5:15 am

    Hi
    I find your tutorials are easy to follow. Could you possibly put a tutorial on how to hide formulas and the same time enter data.

    Reply
    • computergaga says

      10 October 2017 at 7:54 am

      Thanks Stephen. I have a tutorial on this here – http://www.computergaga.com/blog/prevent-formulas-showing-in-the-formula-bar/

      Reply
  2. Sagar says

    29 October 2017 at 6:06 am

    Hi,
    Is this possible to protect formula as well as data entry option without unprotecting the sheet? In your showing option I can’t make data entry without unprotecting the whole sheet.

    Reply
    • computergaga says

      30 October 2017 at 3:44 pm

      Sure. You need to unlock the cells which you need the data entry for first and then protect the sheet. Cells that are locked get protected, cells that are not don’t.
      The tutorial shows using Format Cells to unlock cells before protecting a sheet.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·