Unable to Read Row and Column Heading Text in Excel

Last reviewed: November 3, 1994
Article ID: Q71747
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 5.0

SUMMARY

If a ButtonFace parameter is present in the [colors] section of your WIN.INI file, Microsoft Excel uses this color for your row and column headings and status bar. However, the color for the row and column heading text, as well as the gridlines, is determined by the WindowText parameter rather than the ButtonText parameter. Therefore, if ButtonFace defines a color similar to WindowText, you may not be able to read the text for these items, even though you can see your gridlines; adding a "ButtonText=" line to the WIN.INI file does not solve the problem.

MORE INFORMATION

Steps to Reproduce Problem

  1. Open your WIN.INI file (from the WINDOWS directory) in any text editor, and scroll to the [colors] section.

  2. Make sure that the following lines are in the [colors] section:

          WindowText=0 0 0
          ButtonFace=0 0 0
          ButtonText=255 255 255
    

    This will define WindowText and ButtonFace as black, and ButtonText as white.

  3. Save the changes. Completely exit and restart Windows, as well as Excel.

  4. Notice that the system buttons are black with white text, but the status bar, as well as the row and column headings, are solid black.

Workaround

To solve the problem, either remove the "ButtonFace=" line from your WIN.INI file or make sure that the colors defined for ButtonFace and WindowText are sufficiently different from one another.

REFERENCES

Windows README.TXT file, version 3.1 Windows README.TXT file, version 3.0


KBCategory: kbusage
KBSubcategory:

Additional reference words: 3.0 3.00 4.0 4.00 5.0 5.00 button face


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 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.