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), and then click OK.

See also

Protect workbooks or sheets (2016)

Protect a workbook

Protect a sheet (2011)

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×