Microsoft KB Archive/42291

-

{| 2.x 3.x 4.00 5.00 |2.20 2.21 3.00 | 2.20 3.00 4.00 5.00 WINDOWS          | OS/2          | MACINTOSH kbusage The information in this article applies to:
 * width="100%"|


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0
 * Microsoft Excel for the Macintosh versions 2.2, 3.0, 4.0, 5.0

SUMMARY
When you choose Cell Protection to hide cells on the screen or when you print, the contents of the cells on the screen and in the printout still show.

MORE INFORMATION
Protecting a cell as hidden hides only the formula; the value still appears in the cell. This option is available to protect formulas from being changed. To hide the contents of cells on the screen, and thus on the printout, do the following:

Version 5.0

 * 1) Select the cells you want to hide.

2. From the Format menu, choose Cells. 3. Select the Protection tab and choose Hidden. 4. Select the Number tab and enter the number format.

Version 2.x, 3.x, 4.0

 * 1) Select the cells you want to hide.
 * 2) From the Format menu, choose Number.
 * 3) Create a custom format ;;; (three semicolons with nothing between them).
 * }

-

Last reviewed: December 2, 1994

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.