Borders are printed black when "Black and White" is selected in the Page Setup dialog box in Excel for Mac

This article was previously published under Q183148
This article has been archived. It is offered "as is" and will no longer be updated.
Symptoms
When you print in Microsoft Excel, all borders are printed black regardlessof the color you used to format them. For example, a border formatted withwhite is printed black.
Cause
This problem occurs if the Black And White check box on the Sheet tab inthe Page Setup dialog box is selected. When you select the Black And Whitecheck box, any border color you apply around an object or cell is printedblack.
Workaround
To print without borders, remove the border. To do this, use one of thefollowing methods depending whether you want to remove the border from textor from an AutoShape.

Method 1: Removing the border around cells

  1. Select the Cells with borders that you want to remove. On the Format menu, click Cells.
  2. In the Format Cells dialog box, click the Borders tab.
  3. In the Line Style box, click None.
  4. Click the Outline button, 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.
  2. 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.
More information
On black-and-white printers, Microsoft Excel prints colors as grayshades. You can reduce the amount of time required by Microsoft Excel toprint a worksheet that contains colors by printing colors in black andwhite. When you print a worksheet by using only black and white, MicrosoftExcel prints fonts and borders formatted in color in black.
References

Excel X and later versions

For more information about troubleshooting cell borders, click Excel Help on the Help menu, type troubleshoot formatting cells, click Search, and then click a topic to view it.

For more information about troubleshooting borders around drawing objects, click Excel Help on the Help menu, type troubleshoot drawing objects, click Search, and then click a topic to view it.

Excel 2001

For more information about troubleshooting cell borders, click the Office Assistant, type troubleshoot formatting cells, click Search, and then click a topic to view it.

For more information about troubleshooting borders around drawing objects, click the Office Assistant, type troubleshoot drawing objects, click Search, and then click a topic to view it.

Note If the Assistant is hidden, click the Office Assistant button on the Standard toolbar.

Excel 98

For more information about troubleshooting cell borders, click Contents AndIndex on the Help menu (or on the Balloon Help menu if you are using aversion of the Macintosh operating system earlier than 8.0), click theIndex button in Microsoft Excel Help, type borders, cells, and then click Show Topics. Select the Troubleshoot formatting cellstopic, and then click Go To. If you cannot find the information that 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 ifyou are using a version of the Macintosh operating system earlier than8.0), click the Index button in Microsoft Excel Help, type borders, drawing objects, and then click Show Topics. Select the Troubleshoot adding borders, fills,shadows, and 3-D effects to drawing objects topic, and then click Go To. If youcannot find the information that you need, ask the Office Assistant.

Note If the Assistant is hidden, click the Office Assistant button on the Standard toolbar.
XL98 XL2001 XLX XL2004
Properties

Article ID: 183148 - Last Review: 11/02/2013 11:51:00 - Revision: 4.0

Microsoft Excel 2004 for Mac, Microsoft Excel X for Mac, Microsoft Excel 2001 for Mac, Microsoft Excel 98 for Macintosh

  • kbnosurvey kbarchive kbprb kbprint KB183148
Feedback