How do I copy color-coded texts from EXCEL to WORD in the same format?

In the past, I used "Paste Specials" then "Picture (Enhanced Metafile)" and
I could paste all color-coded texts from EXCEL in the same format into WORD.
However, recently when I copy color-coded texts from EXCEL to WORD, they
simply appear Black/White.

Please help!!

What changes have you made between the past and present?

Could be a clue there?

These are the steps I would take.

SHIFT + EditCopy PictureAs shown on screenas pictureOK

Open a Word doc and EditPaste SpecialEnhanced Metafile


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:52:00 -0800, Hope 2002 <Hope
wrote:

How do I copy color-coded texts from EXCEL to WORD in the same format?

In the past, I used "Paste Specials" then "Picture (Enhanced Metafile)" and
I could paste all color-coded texts from EXCEL in the same format into WORD.
However, recently when I copy color-coded texts from EXCEL to WORD, they
simply appear Black/White.

Please help!!

Unfortunately Gord's method results in the cell lines being shown as well. I
used to just copy the Excel text, go to Word editpaste special windows
metafile and everything came across fine. I now have a new computer, with the
same software versions (Office Professional 2003), but the text come across
black. I have Office Student & Teacher at home and using the process above,
the text comes across in colour without the lines. This suggests to me there
is some set up in either Word or Excel on my new computer which is causing
the problem. Very frustrating.

Any help in solving this problem would be appreciated - thnaks

"Gord Dibben" wrote:

What changes have you made between the past and present?

Could be a clue there?

These are the steps I would take.

SHIFT + EditCopy PictureAs shown on screenas pictureOK

Open a Word doc and EditPaste SpecialEnhanced Metafile


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:52:00 -0800, Hope 2002 <Hope
wrote:

How do I copy color-coded texts from EXCEL to WORD in the same format?

In the past, I used "Paste Specials" then "Picture (Enhanced Metafile)" and
I could paste all color-coded texts from EXCEL in the same format into WORD.
However, recently when I copy color-coded texts from EXCEL to WORD, they
simply appear Black/White.

Please help!!

You could turn the Gridlines off before copying the picture (and turn them
back on again afterwards). Click Tools/Options to bring up the Options
dialog box, click the View tab... the checkbox controlling the visibility is
in the "Window options" section at the bottom of the dialog page... the
label for the checkbox is "Gridlines".

Rick


"mike" wrote in message
...
Unfortunately Gord's method results in the cell lines being shown as well.
I
used to just copy the Excel text, go to Word editpaste special windows
metafile and everything came across fine. I now have a new computer, with
the
same software versions (Office Professional 2003), but the text come
across
black. I have Office Student & Teacher at home and using the process
above,
the text comes across in colour without the lines. This suggests to me
there
is some set up in either Word or Excel on my new computer which is causing
the problem. Very frustrating.

Any help in solving this problem would be appreciated - thnaks

"Gord Dibben" wrote:

What changes have you made between the past and present?

Could be a clue there?

These are the steps I would take.

SHIFT + EditCopy PictureAs shown on screenas pictureOK

Open a Word doc and EditPaste SpecialEnhanced Metafile


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:52:00 -0800, Hope 2002 <Hope
wrote:

How do I copy color-coded texts from EXCEL to WORD in the same format?

In the past, I used "Paste Specials" then "Picture (Enhanced Metafile)"
and
I could paste all color-coded texts from EXCEL in the same format into
WORD.
However, recently when I copy color-coded texts from EXCEL to WORD, they
simply appear Black/White.

Please help!!

Did you think of removing gridlines or making background color white before
taking the picture?


Gord Dibben MS Excel MVP

On Sat, 26 Jul 2008 21:16:01 -0700, mike
wrote:

Unfortunately Gord's method results in the cell lines being shown as wel

Yes thank you, I have looked at removing the gridlines, but did not think
about making the background white. This will help, but it would have been
nice to know what has caused the problem, given the same version of the
software worked fine on an earlier laptop and my Student @ Teacher 2003
version at home brings the text across to Word in colour without having to
use the steps suggested.

thanks for your guidance.

mike

"Gord Dibben" wrote:

Did you think of removing gridlines or making background color white before
taking the picture?


Gord Dibben MS Excel MVP

On Sat, 26 Jul 2008 21:16:01 -0700, mike
wrote:

Unfortunately Gord's method results in the cell lines being shown as wel