SUMMARY
To format a cell in Microsoft Excel so that it will not display text
or numbers, you must apply a white number format to the cell. Because
white is the background color, any cell that is formatted to show its
contents in white will be hidden from view. To format a cell to show
anything as white (hide all), do the following:
- Select the cell(s).
- From the Format menu, choose Number.
- Enter "General[white]" in the Format field.
- Click OK. Any entry into the cell(s) will not display on the
worksheet but will display in the formula bar.
To format a cell to show numbers, but not show text, do the following:
- Select the cell(s).
- From the Format menu, choose Number.
- Enter "General;@[white]" in the Format field.
- Click OK. Numeric values will display on the worksheet and text
will display in white.
It is not possible to hide text on worksheets in versions of Microsoft
Excel prior to version 1.50.
To keep the value from displaying in the formula bar as well as in the
cell(s), you must the following in addition to the procedure you
performed above:
- Select the cell(s) to be hidden.
- From the Format menu, choose Cell Protection.
- Select Hidden and click OK.
- Select all the cells that need to be editable.
- From the Format menu, choose Cell Protection.
- Deselect Locked and click OK.
- From the Options menu, choose Protect Document and enter a password
if desired.
- Click OK. Any value now entered into these cell(s) will not be
displayed in the formula bar.
|