Excel: Hiding Text or Values on a Worksheet

Last reviewed: November 2, 1994
Article ID: Q32550

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:

  1. Select the cell(s).

  2. From the Format menu, choose Number.

  3. Enter "General[white]" in the Format field.

  4. 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:

  1. Select the cell(s).

  2. From the Format menu, choose Number.

  3. Enter "General;@[white]" in the Format field.

  4. 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:

  1. Select the cell(s) to be hidden.

  2. From the Format menu, choose Cell Protection.

  3. Select Hidden and click OK.

  4. Select all the cells that need to be editable.

  5. From the Format menu, choose Cell Protection.

  6. Deselect Locked and click OK.

  7. From the Options menu, choose Protect Document and enter a password if desired.

  8. Click OK. Any value now entered into these cell(s) will not be displayed in the formula bar.


KBCategory: kbother
KBSubcategory:

Additional reference words: 1.50 2.20 3.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.