Microsoft KB Archive/107076: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 56: | Line 56: | ||
<pre> formatting cells, colors | <pre> formatting cells, colors | ||
</pre> | </pre> | ||
and then double-click the selected text to go to the | and then double-click the selected text to go to the "Shade cells with solid colors" topic. | ||
"User's Guide," version 5.0, page 242 "User's Guide," version 4.0, page 536 | |||
For more information about the Page Setup Command (File Menu), choose the Search button in Help and type: | For more information about the Page Setup Command (File Menu), choose the Search button in Help and type: | ||
Line 79: | Line 79: | ||
<br /> | <br /> | ||
<br /> | <br /> | ||
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED | 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. | ||
</blockquote> | </blockquote> | ||
<span>Last reviewed: December 19, 1996</span><br /> | <span>Last reviewed: December 19, 1996</span><br /> | ||
[[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /> | [[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /> | ||
|} | |} |
Revision as of 10:20, 20 July 2020
Microsoft Knowledge Base
Excel: No White Text on Black with Black And White Option
Last reviewed: December 19, 1996
Article ID: Q107076
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
- Microsoft Excel for the Macintosh, versions 4.0, 5.0
- Microsoft Excel for Windows 95, version 7.0
- Microsoft Excel 97 for Windows
SUMMARY
In Microsoft Excel, if you have the Black And White (Black & White Cells in versions 4.0, 4.0a) option selected in the Page Setup dialog box, cells formatted with white text on a black background will not print as formatted. Instead, they are printed and appear in print preview as black text on a white background. However, text boxes with the same formatting, will print with white text on a black background even with the Black and White option turned on (except in Microsoft Excel 97).
Steps to Reproduce Problem
Enter the following data in a new worksheet:
A1: one A2: two
and select these cells.
Format the selected cells with white text on a black background and select the Black And White print option with the following steps:
Versions 5.0, 7.0 and 97 ------------------------
a. On the Format menu, click Cells.
b. In the Format Cells dialog box click the Patterns tab. Select black from the Colors box under Cell Shading.
c. Click the Font tab, select white from the Color drop-down list and click OK.
d. On the File menu, click Page Setup.
e. Click the Sheet tab and under Print, click the Black And White check box. Click OK.
f. On the File menu click Print Preview.
Versions 4.0, 4.0a ------------------
a. From the Format menu, choose Patterns, and select black from the Foreground list. Choose OK.
b. From the Format menu, choose Font, and select white from the Color list. Choose OK.
c. From the File menu, choose Page Setup.
d. Select the Black & White Cells check box and choose OK.
- From the File menu, choose Print Preview.
The cells formatted as white text on black background will be displayed as black text on a white background. They will also print out this way.
NOTE: Text boxes formatted with white text on a black background will print as formatted, even with the Black and White print option selected in the Page Setup dialog box (except in Microsoft Excel 97).
REFERENCES
For more information about Formatting Cells, click the Index tab in Microsoft Excel 97 Help, type the following text
formatting cells, colors
and then double-click the selected text to go to the "Shade cells with solid colors" topic.
"User's Guide," version 5.0, page 242 "User's Guide," version 4.0, page 536
For more information about the Page Setup Command (File Menu), choose the Search button in Help and type:
setting up pages
-or-
setting up documents (versions 4.0, 4.0a)
KBCategory: kbusage Last reviewed: December 19, 1996 |