Don't want to print colors

  • Thread starter Thread starter Learning Excel
  • Start date Start date
L

Learning Excel

I use a lot of colors in my worksheet, but when it comes to print I do not
really
need them at all times.
Q : Is there a setting to print a worksheet that have colors but
getting a printout just with the context ( no colors ).
 
File | Page Setup | Sheet (tab)
Checkmark: "Blank and white"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
--
"Flogging will continue until the mood of the crew improves"




"Learning Excel"
wrote in message
I use a lot of colors in my worksheet, but when it comes to print I do not
really
need them at all times.
Q : Is there a setting to print a worksheet that have colors but
getting a printout just with the context ( no colors ).
 
Typo...
"Black and white" not "Blank and white"



File | Page Setup | Sheet (tab)
Checkmark: "Blank and white"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
--
"Flogging will continue until the mood of the crew improves"




"Learning Excel"
wrote in message
I use a lot of colors in my worksheet, but when it comes to print I do not
really
need them at all times.
Q : Is there a setting to print a worksheet that have colors but
getting a printout just with the context ( no colors ).
 
Real blindness has nothing to do with the person's eyes.
I've been looking all over the worksheet settings trying to find this answer.
Thanks a lot for your help and time Jim Cone.
 
Learning Excel said:
I use a lot of colors in my worksheet, but when it comes to print I do not
really
need them at all times.
Q : Is there a setting to print a worksheet that have colors but
getting a printout just with the context ( no colors ).
Click to expand...

Two possibilities come to mind.

Save the worksheet
Highlight the whole worksheet (click on the box at the extreme top left) and
change the 'Fill Color' and 'Font Color'
Print
Close the worksheet without saving

Most printer software include an option to print in black only.

Bill Ridgeway
Computer Solutions
 
Back
Top