Share via

How do I hide formulas in Excel?

Anonymous
2021-10-25T12:28:11+00:00

How do I hide formulas in Excel?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-10-25T12:41:09+00:00

    Hi John,

    Do you mean you would like to hide the formula bar in Excel?

    If so, go to Excel > File > Options > Advanced > Display > tick off Show Formula bar option

    Then click on OK to save your change.

    If this is not what you want, could you provide us a screenshot on which part you would like to hide？

    Regards,

    Alex Chen

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2021-10-25T12:52:53+00:00

    re: "hide formulas"

    The formula =IF(A1 > 10, True, "") is hidden, if Cell A1<=10

    by the use of two sets of quote marks.

    You could also change the font color of the cell to white.
    (not recommended)

    To find all formulas on a worksheet use...

    Ribbon | Home (tab) | Editing (group) | Find & Select (icon)

    [Edit-added]

    Also, entire rows or columns can be hidden.

    '---
    Nothing Left to Lose

    https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

    (free excel programs)

    0 comments
  3. Anonymous
    2021-10-25T13:47:20+00:00

    I have an Excel file that does some calculations.

    I want to be able to hide the formula. See Below. I want to hide the calculations for fields like that for H18 so people can't see or change the calculation.

    0 comments
  4. Andreas Killer 144K Reputation points Volunteer Moderator
    2021-10-25T13:52:30+00:00

    Change the cell protection and protect the sheet.

    Andreas.

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2021-10-25T13:57:16+00:00

    My Excel does't take me through the options you suggest.

    0 comments