How to hide the cell values in Excel without hiding cells

   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:
  
• On the Home tab, in the Number group, click the dialog box launcher:
  

   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:

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.