XL98: Borders Printed Black with "Black and White" Selected

ID: Q183148

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you print in Microsoft Excel, all borders are printed black regardless of the color you used to format them. For example, a border formatted with white is printed black.

CAUSE

This problem occurs if the Black And White check box on the Sheet tab in the Page Setup dialog box is selected. When you select the Black And White check box, any border color you apply around an object or cell is printed black.

WORKAROUND

To print without borders, remove the border. To do this, use one of the following methods depending whether you want to remove the border from text or from an AutoShape.

Method 1: Removing the Border Around Cells

Select the Cells with borders that you want to remove. On the Format menu, click Cells.

In the Format Cells dialog box, click the Borders tab.

In the Line Style box, click None.

Click the Outline button, and then click OK.

Method 2: Removing the Border Around AutoShapes

Double-click the border of the object that contains the border you want to remove.

The Format AutoShape or Format Text Box dialog box appears.

On the Colors and Lines tab, click No Line in the Color list under Line, and then click OK.

STATUS

This behavior is by design of Microsoft Excel 98.

MORE INFORMATION

On black-and-white printers, Microsoft Excel prints colors as gray shades. You can reduce the amount of time required by Microsoft Excel to print a worksheet that contains colors by printing colors in black and white. When you print a worksheet by using only black and white, Microsoft Excel prints fonts and borders formatted in color in black.

REFERENCES

For more information about troubleshooting cell borders, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text


   borders, cells

and then click Show Topics. Select the "Troubleshoot formatting cells" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

For more information about troubleshooting borders around drawing objects, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text


   borders, drawing objects

and then click Show Topics. Select the "Troubleshoot adding borders, fills, shadows, and 3-D effects to drawing objects" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL98

Keywords : kbprint kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb