Excel Tips by Dave

Prevent a formula from displaying in the formula bar

Caution : This procedure also prevents the cells that contain the formula from being edited.

  1. Select the range of cells whose formulas you want to hide. You can also select nonadjacent ranges or the entire sheet.
  2. On the Format menu, click Cells, ( or do Ctrl + 1 above the Q ) and then click the Protection tab.
  3. Select the Hidden check box.
  4. Click OK.
  5. On the Tools menu, point to Protection, and then click Protect Sheet.
  6. Make sure the Protect worksheet and contents of locked cells check box is selected.

Show formulas that were previously hidden by removing protection

  1. If the workbook is shared, unshare it.
  2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
  3. Select the range of cells whose formulas you want to unhide.
  4. On the Format menu, click Cells, ( or do Ctrl + 1 above the Q ) and then click the Protection tab.
  5. Clear the Hidden check box.