Hide formulas from appearing in the edit bar
If you select the cell with a formula, it will be visible in the edit bar:
![Edit bar in Excel for Microsoft 365 Edit bar in Excel 365](/images/tips/244_365/1.png)
To hide the formula in the edit bar, do the following:
1. Select the cell(s) that you wish to hide the formulas for, right-click on it, and select Format Cells... from the popup menu (or click Ctrl+Shift+F):
![Format cells in popup menu Excel for Microsoft 365 Format cells in popup menu Excel 365](/images/tips/excel_button365/format_cells.png)
2. In the Format Cells dialog box, on the Protection tab, check the Hidden checkbox and then click OK:
![Protection, Hidden cells in Excel for Microsoft 365 Protection, Hidden cells in Excel 365](/images/tips/excel_button365/protection_hidden.png)
3. Protect the spreadsheet. To do this, follow the next steps:
3.1. On the Review tab, in the Protect group, click the Protect Sheet button:
![Protect Sheet in Excel for Microsoft 365 Protect Sheet in Excel 365](/images/tips/excel_button365/protect_sheet-tab.png)
3.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 - see Protect Excel spreadsheet options for more details), and then click OK:
![Protect Sheet in Excel for Microsoft 365 Protect Sheet in Excel 365](/images/tips/excel_button365/protect_sheet.png)
After that, the formula will no longer be displayed in the edit bar when the cell is selected.
![Edit bar in Excel for Microsoft 365 Edit bar in Excel 365](/images/tips/244_365/2.png)
See also this tip in French: Masquer les formules pour qu'elles apparaissent dans la barre d'édition.