Follow

How to print Excel-based forms (financial forms, HUD forms, etc.) without background shading

Some Excel-based forms (e.g., financial forms, HUD forms, etc.) have a subtle background shading (usually gray) that is both visible on screen and prints out. Sometimes you may wish to not have this background shading print out (for example, if you are going to send a document via fax). This article explains how to temporarily disable this shading.
Resolution:

To have background shading not appear in your printed document, you must tell Microsoft Excel to print the document in "black and white" only.

For Microsoft Excel 2007

  1. Click on the Page Layout tab, and then click the button in the lower-right corner of the Page Setup section. Excel 2007 Page Layout - Page Setup
  2. On the Page Setup window, click on the Sheet tab and check the box labeled Black and White, then click OK.

You can now print the document and the shaded backgrounds will not appear in your printed document (they will still appear on your screen, however).

For Microsoft Excel 2003 and earlier

  1. Click on the File menu and choose Page Setup.
  2. On the Page Setup window, click on the Sheet tab and check the box labeled Black and White, then click OK.

You can now print the document and the shaded backgrounds will not appear in your printed document (they will still appear on your screen, however).

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk