Lose Excel font colour when pasting to Word or PowerPoint

Y

Yogi Anand

MrExcel MVP

Joined

Mar 12, 2002

Messages

11,454

• Aug 11, 2004

• #2

Re: Lose Excel font colour when pasting to Word or PowerPoin

fraser said:

My Excel tables are formatted to show negative numbers in red. When pasted into MS Word (copy, paste/special, picture) the fonts appear as black. I have a similar problem with some custom chart legends when charts are pasted from Excel to PowerPoint.

These are standard fonts (Arial 9-12).

I did not have this problem with Office 2000. Only with XP and the 2002 versions of the programs.

Am I missing a setting or something?

Click to expand...

Hi fraser:

No -- I don't think you are missing anyting -- although I am using EXCEL 97.

From within EXCEL instead of doing EDIT|Copy,

do SHIFT|Edit|Copy_Picture

then in Word do EDIT|Paste...

and you will have the color from EXCEL preserved.

Let me know how it goes for you!

 

Upvote 0

F

fraser

New Member

Joined

Jun 23, 2002

Messages

28

• Aug 11, 2004

• #3

Re: Lose Excel font colour when pasting to Word or PowerPoin

Thanks Yogi!

I figured there was a simple answer; I just could not find it anywhere.

 

Upvote 0

Y

Yogi Anand

MrExcel MVP

Joined

Mar 12, 2002

Messages

11,454

• Aug 11, 2004

• #4

Re: Lose Excel font colour when pasting to Word or PowerPoin

Hi fraser:

So, I hope you got things working the way you want -- now let us keep EXCELing!

 

Upvote 0

F

filinnn

New Member

Joined

Jun 24, 2010

Messages

1

• Jun 24, 2010

• #5

I had a similar problem when pasting table as a picture (Windows Metafile) or (Enhanced Metafile) to Word. Background colors were missing. Thanks to Yogi's advice I've found out the reason of missing background color. It's "Black and white" print setting in the Excel file.
So alternative solution is following: 'File -> Print preview -> Setup -> Sheet tab -> remove "Black and white" tick'
Hope this will help someone as I've found a lot of similar questions without answers while googling a solution.

 

Upvote 0

T

Ten98

Board Regular

Joined

Aug 24, 2010

Messages

53

• Apr 7, 2011

• #6

Setting your default printer to a colour printer also seems to do the trick.

 

Upvote 0

C

c8503

New Member

Joined

Mar 3, 2010

Messages

28

• Feb 20, 2013

• #7

Thanks Ten98. That was the definitive answer... it seems to be the specific print driver that makes the changes.

 

Upvote 0