Display or hide cell values

If you have a sheet that contains confidential information, such as employee salaries, you can hide the values of those cells by using a custom number format.

Do any of the following:

Hide cell values

When you hide a value in a cell, the cell appears to be empty. However, the formula bar still contains the value.

  1. Select the cells.

  2. On the Format menu, click Cells, and then click the Number tab.

  3. Under Category, click Custom.

  4. In the Type box, type ;;; (that is, three semicolons in a row), and then click OK.

Display hidden cell values

  1. Select the cells.

  2. On the Format menu, click Cells, and then click the Number tab.

  3. Under Category, click General (or any appropriate date, time, or number format other than Custom).

See also

Protect a workbook

Protect a sheet

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×