Sometimes use some Excel formula, but do not want to be known to others, in order to protect the need for confidentiality, to prevent others to see, you should use the following method to hide the following Excel formula.
Before you hide the table, you can see the formula in the edit bar or double-click the cell.
Operation Steps
Step 1: Select the range of formulas you want to hide, press ctrl+1 (number 1) to open the Format cell window-Protect-tick the hide option.
Step 2: Protect the worksheet. This step is important, and only protect the worksheet to hide the formula.
When you protect a worksheet, the cells can't be edited, that is, how about protecting and editing?
Before you protect the worksheet, select the area that you want to edit-the lock option is canceled in the Protection tab of the Format Cells window. then protect the worksheet.