How to Hide Formula in Excel
To hide formulas follow these simple steps: Step1: Un-Protect Worksheet At this point when you click on a cell, it shows you the entire formula in the formula bar. First of all, you need to make sure that your worksheet in unprotected. For this, go to review tab and in protect the group. If you find a “Unprotect Worksheet” button there, that means your worksheet is protected and you need to unprotect it. Click on that button to un protect it. If you have “Protect Sheet” button there that means your worksheet is unprotected. In that case, skip above steps and start from here. Step2: Activate Hide Formula Option Now, select the cell or range of cell, or select all the non-contiguous cells where you want to hide formulas. After that, right-click and select format cells option. From format cells option, go to protection tab. In protection tab, you have two check boxes to mark, first locked and second is hidden....