How do I 'Print Preview an excel worksheet in color?

[Carole]

I'm using XP and need to 'print preview' in color. Mine is black and white.
How do I change this setting?

[Bernard Liengme]

Hi Carole,
I'm afraid you will have to lie! You need to install a printer that does
colours and set this as the printer to be used by your workbook. It does not
matter that you do not have this printer - unless you hit the Print icon!
Now print preview is in colour. Suggestions: any HP DeskJet printer, or if
it shows up as an installed printer, Microsoft Document Image Printer
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Carole" <[email protected]> wrote in message
news:[email protected]...
> I'm using XP and need to 'print preview' in color. Mine is black and
> white.
> How do I change this setting?

[Carole Drake]

Thanks Bernard. I will get our IT person on it. I'm not 'authorized' to set
up printers.
Carole
"Bernard Liengme" wrote:

> Hi Carole,
> I'm afraid you will have to lie! You need to install a printer that does
> colours and set this as the printer to be used by your workbook. It does not
> matter that you do not have this printer - unless you hit the Print icon!
> Now print preview is in colour. Suggestions: any HP DeskJet printer, or if
> it shows up as an installed printer, Microsoft Document Image Printer
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Carole" <[email protected]> wrote in message
> news:[email protected]...
> > I'm using XP and need to 'print preview' in color. Mine is black and
> > white.
> > How do I change this setting?
>
>
>

[cycling-rod]

Surely, Carole, you already have a printer installed? On my XP, using excel97, coloured cells and font show in Print Preview - coloured! Go into Print Preview > Setup > Page Setup > Sheet, and see if you have a ticked button for Black and White in the Print section. If so untick and see if colour is now shown in Print Preview.