Free Microsoft Excel 2013 Quick Reference

Excel documents not printing in color

I am having this strange issue where I select "Color" in the printing preferences when printing a workbook. The workbook has multiple work sheets, and when I print out the entire workbook, only one random page will print in color, it is odd. The rest are in black. Not sure why it does this.


Post your answer or comment

comments powered by Disqus
Why will my Excel charts not print in color?

I had something in Excel that was copied into Word (using copy, paste special
and pasted as an "Excel object"). Part was in color. Within Print Preview,
it showed in color, but when printing it to a color printer, the colored text
printed in black and white. We even tried printing to another color printer
and it didn't work. Copying it over as a table worked, but it was too big to
size on one page, so I copied it over as a "bitmap" and it worked fine. But,
this was a work-around.

Can anyone help?

Thanks!

dmotika

I had something in Excel that was copied into Word (using copy, paste special
and pasted as an "Excel object"). Part was in color. Within Print Preview,
it showed in color, but when printing it to a color printer, the colored text
printed in black and white. We even tried printing to another color printer
and it didn't work. Copying it over as a table worked, but it was too big to
size on one page, so I copied it over as a "bitmap" and it worked fine. But,
this was a work-around.

Can anyone help?

Thanks!

dmotika

I am not able to print an Excel worksheet in black, but it will print in
color. I am using XP Home Edition and Office 2003 Suite. I have reinstalled
the printer driver and it will still not work. I also cannot print
envelopes. Any suggestions?

Code:
Option Explicit
Sub Test1()
With Sheet2.PageSetup
    .Orientation = xlLandscape
    .BlackAndWhite = False
End With
Application.PrintCommunication = True
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False
End Sub

m setting .BlackAndWhite = False however it still prints in grayscale.
I tried .color = False but still wont work.
Please advice.

My excel 2000 worksheet displays in color but when I try to print it to a
color printer the print preview and the output are both black & white

The Excell spreadsheet prints in color, but the highlighed areas do not show
up on screen. Any suggestions about how to fix this?

I have an Excel workbook with multiple worksheets (14). The Book was created in Excel 2003. Now it is being updated in Excel 2007. The sheets and associated charts display on screen in color but only the sheets that were created since moving to 2007 will preview and print in color. All the sheets that were created under the 2003 version of Excel preview and print in gray scale. The workbook is still being saved in a 2003 compatible version so that it can be shared with users who are not running the newer version.

We would like all sheets to print in color. What option, what setting haven't I found?

I have an Excel 2003 spreadsheet with areas that have been assigned colors.
The colors show on the screen the way I expect. However, I can not get this
one file to print in color. Other files print correctly. I have looked
under file - page setup - sheet tab and made sure black and white is NOT
selected, but still no luck. I have also reloaded the printer drivers.

any help would be appreciated.

*Note* I have made sure that the B&W option was not checked, I'm not printing in draft quality either.

We just replaced our old HP CP2025N with a brand new CP2025N. The old one would print color in excel just fine but I'm having a problem getting the new one to do so. I'm using the PCL 6 drivers for the printer and in every other program I have no problems printing color. I've uninstalled and reinstalled the printer twice to no avail.

The print preview shows color, all the settings reflect that I want a color document to print and it still comes out gray scale.

Any help on this would be appreciated!

I recently installed Office Student & Teacher Edition and have been unable to
get documents to save in the programs [Excel, PowerPoint, Word]. I did
finally get the Word docs to save correctly [not as a Wordpad doc] by
entering "winword /r" at the run command, which re-registered the Word
software. Does anyone know what command to use for re-registering Excel and
PowerPoint?

I opened Excel 2003 worksheet in Excel 2007. Graphics (bitmap, JPEG, etc.
from file) in Excel 2007 worksheet do not print in same location as shown on
the display. Printed correctly in Excel 2003. Print Preview in Excel 2007
also does not display the graphics correctly. Using Dell Inspiron 9100 with
ATI Mobility RADEON 9800 display adapter.

My excel sheets aren't previewing or printing in color, I always get a black
and white print. I scanned my logo and try to use it in excel sheets but i
can't seem to get a color printout.

Please I need help, mi excel doesnt print in color, Ive tried everithing and i just can get it , even in the print preview i cant see colors...

I have been looking through countless threads, but it's frustrating to me that a simple function such as printing in color is so difficult when so many other tasks can be performed with ease. I have started my printing routine by using code from the "record a macro" option. However, when I record a macro and go into the actual properties of my specific printer, it does not capture things such as print in color or staple the top left corner. I have read that its necessary to either write code to change the registry settings or alternatively I could somehow use the sendkey method.
In the printer properties screen, it allows me to save the settings as a .sav file. This seems to be the most helpful, but I dont know what code I would write to call or "load" that file. Since Id prefer not to mess with the registry, could someone fill me in on how I would use sendkeys for this task or how to load that .sav file?
Thank you.

Why do my excel documents not open from the desktop? I can only open
documents when I am already in Excel. I assume some setting is off. Where
should I look? Thanks

I have a color printer that is set to grayscale as a default. When I print my
excel workbook and select it to print in color in the print driver properties
the first page prints in color but the other pages print in black and white
even though the other pages are in color.

My spreadsheet is also for display and I would like to print in color but I have yellow highlighted cells or my employess to know which cell need changing and to imput. Is there a way to highlight a cell and not have it print the color.

Thanks

Dave, thanks for your response.

I copied one of the graphs that was affected to a new worksheet, and
yes the label did print. So from that test i can assume it is not a
problem with the printer drivers.

Does anyone have ideas on this?

###############################################
My spread has several sheets and two of these have eight graphs on
each
- all sized to fit on one A4 page per sheet.

Since i have upgraded to Excel 2003 from 2000, some chart titles no
longer print. I have upgraded my printer drivers and also tried this
on
other Excel 2003 machines, and they have the same problem.

However, if i go back to an Excel 2000 machine it prints fine.

The report is distributed to users of both versions.
Any ideas how to fix this?
Message 2 in thread
From: Dave Peterson (ec35720@netscapeXSPAM.com)
Subject: Re: Chart labels do not print in 2003

View this article only
Newsgroups: microsoft.public.excel
Date: 2004-12-10 13:57:59 PST

I don't really have a guess.

Have you tried it on different printers (if you have them available)?

If you create a small test workbook with just one graph, does that
work ok?

Winshent wrote:
>
> My spread has several sheets and two of these have eight graphs on each
> - all sized to fit on one A4 page per sheet.
>
> Since i have upgraded to Excel 2003 from 2000, some chart titles no
> longer print. I have upgraded my printer drivers and also tried this on
> other Excel 2003 machines, and they have the same problem.
>
> However, if i go back to an Excel 2000 machine it prints fine.
>
> The report is distributed to users of both versions.
> Any ideas how to fix this?
--

Dave Peterson

Is it possible to make a user form asking "print in colors or black/white" ? also another question save as "pdf" ?

Thank You

Is there a way using vba to go around this ?
I want all sheets to print in color.

Thanxxx,
Luc

I'm creating a macro in my worksheet to print a range with a network printer. The networkprinter is set for standard printing in black. Is it possible to put in vba a code so it prints in color?
This is what I have fornow:

Sub Printen2()
Dim STDprinter As String
    STDprinter = Application.ActivePrinter
    Application.ActivePrinter = "BETPBRU-PS01.main.glb.corp.localBETPATA-P00FC02 op Ne04:"
    ' change printer

    Range("A1:AI38").Select
    Selection.PrintOut
    ' prints the range

    Application.ActivePrinter = STDprinter
    ' change back to standard printer

End Sub
Thx

How do I make my Excel-document automatically display in full screen-mode when it is loaded?

I have just begun using Excel and have changed the font colors as well as the
cell colors in a document. However, when I try to print it, it comes out
only in Black and White. I am sure it must be something basic and I have
checked my printer, but to no success. Can someone please help me?
Thanks much!


No luck finding an answer? You could always try Google.