See all How-To Articles

How to Hide Formulas in Excel & Google Sheets

This tutorial shows how to hide formulas in Excel.

 

hide formulas 8

 

Hide Formulas in Excel

In Excel, if a cell contains a formula, that formula is displayed in the formula bar when the cell is selected. But if you don’t want to display formulas for proprietary, security, or confidentiality reasons, you can easily hide them.

 

hide formulas 1

 

  1. Select the cell with the formula you want to hide, then in the Ribbon go to Home > Format > Format Cells.

 

hide formulas 2

 

  1. In the Format Cells window, go to Protection, check the box next to Hidden, and click OK.

 

hide formulas 9

 

  1. To make the formula-hiding feature work, you need to protect your workbook. In the Ribbon, go to Review and click on Protect Sheet.

 

hide formulas 4

 

  1. In the Protect Sheet window, type in a password and press OK.

 

hide formulas 5

 

  1. In the Confirm Password window, reenter the password and click OK.

 

hide formulas 6

 

As a result, the formula is locked and hidden. When you click on the cell, you won’t be able to see the formula in the formula bar.

 

hide formulas 7

 

Hide the Formula Bar

Another way to hide the formula is to hide the whole formula bar. In the Ribbon, go to View and uncheck the box next to the Formula Bar.

 

hide formulas 10

 

Keep in mind this won’t actually hide the formula for protection reasons. Anyone can enable the Formula Bar later and see the formula.

Hide Formula Bar in Google Sheets

Say you have a formula in cell B6 and want to hide it. In Google Sheets, you can’t hide this formula the same way you can in Excel; but what you can do is hide the whole formula bar.

 

hide formulas 11

 

In the Menu, go to View > Formula bar to disable this option.

 

hide formulas 13

 

Now, the formula bar is hidden, and you won’t be able to see the formula.

 

hide formulas 12

 

Alternatively, if you want to protect the formula from further edits you can lock the cell as a protected range.