Disguise or show cell values

Disguise or show cell values

Suppose you might have a worksheet that incorporates confidential data, similar to worker salaries, that you don’t want a co-worker who stops by your desk to see. Or maybe you multiply the values in a variety of cells by the worth in one other cell that you don’t want to be seen on the worksheet. By making use of a customized quantity format, you possibly can conceal the values of these cells on the worksheet.

Observe: Though cells with hidden values seem clean on the worksheet, their values stay displayed within the method bar the place you possibly can work with them.

Disguise cell values

  1. Choose the cell or vary of cells that incorporates values that you simply need to conceal. For extra data, see Choose cells, ranges, rows, or columns on a worksheet .

    Observe: The chosen cells will seem clean on the worksheet, however a worth seems within the method bar while you click on one of many cells.

  2. On the House tab, click on the Dialog Field Launcher Button image subsequent to Quantity.

    Excel Ribbon Image

  3. Within the Class field, click on Customized.

  4. Within the Kind field, choose the prevailing codes.

  5. Kind ;;; (three semicolons).

  6. Click on OK.

Tip: To cancel a collection of cells, click on any cell on the worksheet.

Show hidden cell values

  1. Choose the cell or vary of cells that incorporates values which can be hidden. For extra data, see Choose cells, ranges, rows, or columns on a worksheet .

  2. On the House tab, click on the Dialog Field Launcher Button image subsequent to Quantity.

    Excel Ribbon Image

  3. Within the Class field, click on Common to use the default quantity format, or click on the date, time, or quantity format that you really want.

Tip: To cancel a collection of cells, click on any cell on the worksheet.

Leave a Reply