MS-Excel / General Formatting

Excel Hide Cell Formulas

  1. Select the cells containing formulas or information you want to hide.

  2. Choose Home> Cells> Format> Formet Cells. This displays the Format Cells dialog box.
    Click the Protection tab and select the Hidden option.

  3. Click ok.
    Although you see the results of the formula in cell F12, the formula bar does not display the actual formula.
[Previous] [Contents] [Next]

In this tutorial:

  1. Protecting Excel Data
  2. Quickly Hide an Open Workbook
  3. Make a File Read-Only
  4. Mark a Workbook as Final
  5. Inspecting a Workbook
  6. Hide and Unhide Columns and Rows
  7. Excel Unlock Cells
  8. Protect Worksheets
  9. Excel Restrict User Data Entry
  10. Excel Assign a File Password
  11. Excel Hide Cell Formulas
  12. Protecting a workbook's structure
  13. Using a digital signature in Excel
  14. Signing a Workbook