File Saved in XL4 from Lotus 1-2-3 Does Not Display Gridlines

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows

SYMPTOMS

In Lotus 1-2-3 version 5.0, you can save a file as a Microsoft Excel 4.0 worksheet or workbook. When one of these files is opened in a version of Microsoft Excel listed at the beginning of this article, the gridlines may not be displayed. This problem will occur even though the gridlines are turned on in the View tab of the Options dialog box in Microsoft Excel.

CAUSE

The gridlines are not displayed because the pattern of the Normal Style is set to the color white.

RESOLUTION

To display the gridlines, you can use the following steps:

1. On the Format menu, click Style.

2. In the Style dialog box, in the Style Name box, select or type Normal.

3. Click Modify, and then click the Patterns tab.

4. Under Color, select No Color (in version 97) or None (in versions 5.0 and 7.0).

5. Click OK twice to return to the worksheet.

1. Under Color, select any color except for No Color or for None.

2. Click OK twice to close the Style dialog box.

3. Repeat steps 1-5 above.

MORE INFORMATION

Lotus 1-2-3 is manufactured by Lotus Corp., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this products' performance or reliability.