Hide formulas from appearing in the edit bar

Excel 365 2013 2010 2007 2003
Usually, you can view formula in the Excel the cell when cell is selected, but you can protect a spreadsheet to hide formulas in some cells.

If you select the cell with a formula, it will be visible in the edit bar:

Edit bar in Excel 2016

To hide the formula in the edit bar, do the following:

   1.   Un-protect all of the cells on the sheet. To do this, do the following:

   1.1.   Select all of the rows and columns in your sheet and right-click on the selected cells.

   1.2.   Select Format Cells... on the popup menu (or click Ctrl+Shift+F):

Format cells in popup menu Excel 2016

   1.3.   In the Format Cells dialog box, on the Protection tab, uncheck the Locked checkbox and then click OK:

Protection, Locked cells in Excel 2016

   2.   Select the cell(s) that you wish to hide the formulas for, right-click in it, and select Format Cells... from the popup menu (or click Ctrl+Shift+F).

   3.   In the Format Cells dialog box, on the Protection tab, check the Hidden checkbox and then click OK:

Protection, Hidden cells in Excel 2016

   4.   Protect the spreadsheet. To do this, follow the next steps:

   4.1.   On the Review tab, in the Changes group, click the Protect Sheet button:

Protect Sheet in Excel 2016

   4.2.   In the Protect Sheet dialog box, on the Password to unprotect sheet box, type a password for the sheet, if you wish (Password is optional, for more details see Protect Excel spreadsheet options), and then click OK:

Protect Sheet in Excel 2016

After that, the formula will no longer be displayed in the edit bar when the cell is selected.

Edit bar in Excel 2016

See also this tip in French: Masquer les formules pour qu'elles apparaissent dans la barre d'édition.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more