Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Dallas, TX

    Red face Unanswered: Remove shading when printing

    Good morning,

    I am using Excel 2007 and need assistance in solving a bit of an annoyance when work is faxed in to me. The depts when FAXing in there Excel spreadsheets they have Shading in certain areas that come out just black when it is faxed in. I understand they need the shading on their end for some reason, but how can I help them in coding it to remove all shading temporarily while they print the sheets out to fax, but then reinstates the shading as if nothing ever happened? If you could help me out with some simple basic coding to do this I would greatly appreciate it.

    Have a nice day

  2. #2
    Join Date
    May 2011
    The solution is pretty simple. Tell them to go to print setup, then to the "Sheet' tab and put a checkmark beside "DRFT QUALITY" option. That will remove all the shading. Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts