At work I print alot of colorcoded spreadsheets. The headers for all of these are black with white font. When I print, It just comes out black. On some spreadhsheets it will show the white font if i make the backgroung the dark (almost black) grey color. but not always.
How do i change my settings so that my laserjet prints the font as white on the black background?
We have another printer here and it prints fine, but it is a tektronix (uses wax) and takes for ever to print, also the laserjet is at my desk.. so i need to make it work here.
I am printing these in black and white, my laserjet doesnt do color.
You need to check this settings
File > Page Setup > Sheet > Draft Quality
AND
File > Page Setup > Sheet > Black and White
This setting is in Excel and does not affected by the type of the printer.
And also, you need to check this option for each sheet and for each file
Trust me, I am the VBAXLMan here
Comment by VBAXLMan — July 24, 2010 @ 11:17 am