How to hide the cell values in Excel without hiding cells

Excel 2016
Conditional formatting of Excel cells simplifies highlighting values by adding color scales, data bars, sparklines, and in-cell icons to the cell. The exact values of the highlighted cells are rarely meaningful and may even interfere with the perception of information. Custom cell format allows hiding values of such cells without hiding the cells.
Hidden cell values in Excel 365

   1.   Select cells which values you want to hide and do one of the following:

  • Right-click on the selection and choose Format Cells... in the popup menu:
    Format cells in popup menu Excel 365
  • On the Home tab, in the Number group, click the dialog box launcher:
    Format cells in Excel 365

   2.   In the Format Cells dialog box, on the Number tab, select the Custom formatting, and then in the Type field, type ";;;" to hide any value in the cells:

Format Cells dialog box in Excel 365

Note: The format code has four sections separated by semicolons:

Positive; Negative; Zero; Text

The empty sections mean no visible content to show.

See Custom cell format for more details.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.