Once you click OK it Excel will select all the cell from worksheet where you have formulas. Select the cells for which you to want to hide the formulas. In this tutorial we will learn about How to Protect Formula in Excel and How to Hide Formula in ExcelDownload Protect Formula in Excel Practice File.
When the Format Cells window appears select the Protection tab.
Select Formulas option and its all four sub option Numbers Text Logicals Errors and click OK. To Unprotect the SheetThe first step is to make sure that the worksheet is unprotected. Switch between displaying formulas and their results Prevent a formula from displaying in the formula bar Show formulas that were previously hidden by removing protection. This property is under the Application object.