Skip to content

How to Hide Your Formulas in Excel

For some reason, let’s say you want to hide the formulas you have written in your Excel spreadsheet. In other words, you want to protect your workbook and keep formulas from showing up in the formula bar.

Here is how you can do this!

The Process

To hide your formulas from view, follow the steps below.

  1. Select the cells where you want to hide the formula.
  2. Change the protection formatting to locked and hidden.
  3. Protect the worksheet.

Step 1

For the first step, select the cells containing formulas you want to hide.

With the cells selected, right-click and select Format Cells.

Step 2

In the Format Cells dialog box, navigate to the protection tab.

Check the boxes for Locked and Hidden. Then click on Ok.

Step 3

Protect the worksheet by going to ReviewProtect Sheet.

Enter a password if you want, and then click on Ok.

Re-enter the password if you added one, and then click on Ok.

The formulas will now be hidden from the formula bar whenever a locked and hidden cell is selected.

And that is how you can hide your formulas in Microsoft Excel!

This Post Has One Comment

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top