Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

Print Preview in Color

Posted by steven on January 30, 2002 4:57 AM

I have a spreadsheet that contains many cells with one of 4 different colors. When I use print preview sometimes the preview is in black and white, other times it is in color. The use of color vs. black/white seems random - I know there must be some reason. Is there any way I can specifically indicate I want color or black/white preference?

Re: Print Preview in Color

Posted by Juan Pablo G. on January 30, 2002 7:48 AM

1. Select the cell range where the value is to
be entered.
2. After typing the value, press Control+Enter.

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.