Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/107076

From BetaArchive Wiki

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

  1. Enter the following data in a new worksheet:

        A1: one
        A2: two
        and select these cells.
  2. 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.
  3. 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

KBSubcategory: xlprint xldraw xlformat

Additional reference words: 4.00 4.00a 5.00 7.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: December 19, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.