Black and White Blues

Excel allows you to create a colorful masterpiece on your screen. What you get when you print, however, depends entirely on the printer you are using. Some black-and-white printers do a great job of translating colors into shades of gray. Others, however, leave quite a bit to be desired in their output.

If you are having problems printing color Excel information on your black-and-white printer, try these steps:

  1. Display the Page Layout tab of the ribbon.
  2. Click the small icon at the bottom-right of the Sheet Options group. Excel displays the Sheet tab of the Page Setup dialog box. (See Figure 1.)
  3. Figure 1. The Sheet tab of the Page Setup dialog box.

  4. Make sure the Black and White check box is selected.
  5. Click OK.

You are now ready to print, and you should do so as you normally would. You should notice a marked improvement in your printer output.