Pasting charts to Word without Gridlines


B

Brian

I'm trying to paste charts from my Excel 2007 to Word 2007, but the gridlines
(NOT BORDERS) are appearing on my word doc. This didn't happen before today.
When I paste, I use the Paste Special > Picture (Enhanced Metafile). And I
don't want to use the "hide gridlines" on the excel b/c I didn't have to do
it before and I don't want to do that every single time I paste to Word. Any
suggestions?
 
Ad

Advertisements

S

Shane Devenshire

Hi,

Not clear on this one? You can turn gridlines off in a chart by unchecking
Gridlines on the View tab. If you don't want gridlines in a chart, select
the chart and choose Chart Tools, Layout, Gridlines, Primary Horizontal
Gridlines, None.

Generally, I would just do a regular copy and paste of the chart between
Excel and Word 2007, not using picture.
 
B

Brian

After talking with my co-workers I realized this started to happen after we
downloaded a Windows update. Before we didn't have to turn off gridlines for
it not to show in Word.

Windows...can you please change it back???!!
 
R

R.

After talking with my co-workers I realized this started to happen after we
downloaded a Windows update.  Before we didn't have to turn off gridlines for
it not to show in Word.  

Windows...can you please change it back???!!





- Show quoted text -

I'm having the same problem and feel the same about hiding the
gridlines. I've posted on Microsoft's website to see if anyones come
up with a solution. If I get one, I'll post it here.
 
R

redtical

I have also noticed this issue. Not only does it paste gridlines (it didn't
use to), but it also pastes in the red triangle in the corner of a cell that
has a comment (it didn't use to do this either).

The gridlines can be worked around by removing gridlines from the view tab,
or by coloring the cells with a white background.

Is there any workaround for the comments issue, besides deleting or moving
the comment to a different cell (outside of the copied area)???

I agree: Microsoft, please change this back!!
 
J

JAG214

I'm trying to paste charts from my Excel 2007 to Word 2007, but the gridlines
(NOT BORDERS) are appearing on my word doc.  This didn't happen before today.
 When I paste, I use the Paste Special > Picture (Enhanced Metafile).  And I
don't want to use the "hide gridlines" on the excel b/c I didn't have to do
it before and I don't want to do that every single time I paste to Word.  Any
suggestions?

Apparently, after the latest Office Update, there is a new way of
accomplishing this:

Home>Paste>As Picture>Copy As Picture>As shown when printed

(Alt,H,V,A,C,P,Enter) (BTW, the keyboard commands used to be so easy;
thanks Microsoft for the improvements)

This will copy the spreadsheet clipping as we were doing before the
update, then paste to Word as you've been doing. Hopefully, this will
help.
 
Ad

Advertisements

K

kgander

Apparently, after the latest Office Update, there is a new way of
accomplishing this:

Home>Paste>As Picture>Copy As Picture>As shown when printed

(Alt,H,V,A,C,P,Enter) (BTW, the keyboard commands used to be so easy;
thanks Microsoft for the improvements)

This will copy the spreadsheet clipping as we were doing before the
update, thenpastetoWordas you've been doing.  Hopefully, this will
help.

For those who find the Copy as Picture solution cumbersome, and aren't
afraid to run without all the recent Office patches: uninstalling
Security Update for Excel 2007 (KB969682) fixed it for me. Note I had
uninstalled a couple of others before that - KB956358 and KB969604 -
so the fix might be a result of uninstalling all three. Also, don't
forget to hide the update to keep it from coming back.

Let me add: don't expect Office 2007 SP2 to fix this one like it has
other Excel copy/paste problems. SP2 was my first suspect, but after
running the Microsoft Service Pack Uninstall Tool for 2007 the problem
remained.
 
Ad

Advertisements

Joined
Aug 19, 2009
Messages
1
Reaction score
0
This resolution procedure came straight from the Microsoft Excel Support Team. Hope you find it useful.

In Excel2007, you select the cells, choose Home | (Clipboard) Paste | As Picture | Copy as Picture ( Choose As shown when printed and Picture in the dialog box). In Word 2007, at an insertion point, you choose Edit | Paste.

You can also add Copy Picture to the Quick Access Toolbar in Excel 2007: Right click on the QAT | Choose Customize... | Choose commands from: Home Tab | Add "Copy as Picture" to the right side | Press OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top