Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Print without showing cell shadingPosted 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?
Re: Print without showing cell shadingPosted 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.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.