Easy Value Hiding

Excel provides many different ways to hide the content of your workbooks. Perhaps one of the easiest (and most novel) ways is to use the custom formatting feature of the program. Follow these steps:

1. Select the cells whose content you want to hide.
2. Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
3. Make sure the Number tab is displayed. (Click here to see a related figure.)
4. In the list of format categories, select Custom.
5. In the Type box, enter three semicolons (;;;).
6. Click on OK.

Now the information in the cell is not visible, nor will it print. You can, however, see the information in the Formula Bar, and it can be overwritten if you enter anything else in the cell.