MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Print without showing cell shading

Posted by Ghentry on October 23, 2001 5:43 AM

I believe I saw this somewhere before, but cannot find. I have a spreadsheet with a lot of shaded cells which waste printer toner if printed. Is there a way to print without the shading other than having a macro remove the shading, print, restore shading?

Posted by Bob Umlas on October 23, 2001 5:45 AM

Sure -- in Page Setup there's a Sheet tab. On that tab there's a "Black and White" checkbox. Check it and you'll save toner.