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

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×