Don't want to print colors

[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 ).

 

[Jim Cone]

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 ).

 

[Jim Cone]

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 ).

 

[Learning Excel]

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.

 

[Bill Ridgeway]

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 ).

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