Most valuable professional
  • Excel Book Excerpt

Excel Hide Values Using a Number Format

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Hide Values Using a Number Format

Problem: Why did you use the white font to hide those cells? Isn’t there a custom number format to hide values?

Strategy: Yes. You could select the cells, press Ctrl+One, then choose Custom and type three semi-colons to hide the text in the cell.

LE10001233.jpg 

Figure 1189 Using ;;; will hide the cell contents.

Gotcha: While nothing will appear in the cells, if someone selects the cell, they can see the cell formula in the formula bar. If the cell contains a constant (i.e. anything other than a formula), then they will see the cell value as well.

LE10001234.jpg 

Figure 1190 The cells are hidden, except in the formula bar.

The other problem with this method: if the data is being used in a chart, then the labels along both axis of the chart will be hidden as well. Here is the chart before hiding the data:

LE10001236.jpg 

Figure 1191 Both axis have labels.

After hiding the data, the axis labels are gone.

LE10001235.jpg 

Figure 1192 Axis labels are hidden when the range is hidden.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: