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 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 launch pad icon:
    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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more