Microsoft KB Archive/212165

= XL2000: Borders Printed Black with "Black and White" Selected =

Article ID: 212165

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q212165





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 the appropriate method for your situation, depending on whether you want to remove the border from text or from an AutoShape.

Method 1: Removing the Border Around Cells

 * 1) Select the cells that have borders that you want to remove. On the Format menu, click Cells.
 * 2) In the Format Cells dialog box, click the Border tab.
 * 3) Under Line, click None in the Style box.
 * 4) Under Presets, click Outline, and then click OK.

Method 2: Removing the Border Around AutoShapes

 * 1) 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.
 * 1) Click the Colors and Lines tab.
 * 2) Under Line, click No Line in the Color list.
 * 3) Click OK.



MORE INFORMATION
On black-and-white printers, Excel prints colors as shades of gray. You can reduce the amount of time it takes 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, Excel prints fonts and borders formatted in color in black.

Additional query words: XL2000

Keywords: kbprint kbprb KB212165

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.