Excel copy into Word problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allenx - 23 Oct 2007 18:05 GMT

I want to paste an image of a
rather large spreadsheet (including
it's row and column headings) into
an MS Word document. The spreadsheet
itself includes macros, comments and other
stuff, but all I want is an image of the
spreadsheet as it would appear on a printer.

The Excel "Copy" --> Word "Paste Special"
"bitmap" method doesn't
copy the column
and row headings.

The Excel "Copy" --> Word "Paste Special"
"picture" copies the rows and column
headings, but truncates the image for
some reason. .

The same problem happens when I try to
copy the image into PowerPoint.

Any ideas?

Reply to this Message

Bernard Liengme - 23 Oct 2007 18:33 GMT

First: to get the row & column headers. File | Page Setup -> Sheet; set row
and column header on

Second: to copy and paste
Select the area to be copied
Hold down SHIFT and press Edit on menu
There is an item Copy As Picture (not there unless you held down SHIFT)
Select the from menu; in dialog, specified as As Printed (to get the
headers)
Click OK
Move to Word and Paste
Hope this helps - I do this for documentation and book illustrations.
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I want to paste an image of a
> rather large spreadsheet (including
[quoted text clipped - 18 lines]
>
> Any ideas?

Reply to this Message

Allenx - 23 Oct 2007 21:20 GMT

Bernard,

This helps, Thank you.
But an error message tells me my
spreadsheet is "...too big and will be truncated".

I'd rather not make the "picture" multiple pages
because it needs to be all there. .
Any more ideas?

> First: to get the row & column headers. File | Page Setup -> Sheet; set
> row and column header on
[quoted text clipped - 31 lines]
>>
>> Any ideas?

Reply to this Message

Bernard Liengme - 23 Oct 2007 23:20 GMT

What happens if you use the Zoom tool before Copy As Picture?
Download a 30-day trial of SnagIt (www.snagit.com takes you the TechSmith
site) and try that.
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Bernard,
>
[quoted text clipped - 41 lines]
>>>
>>> Any ideas?

Reply to this Message

Allenx - 24 Oct 2007 22:50 GMT

Snag It works like a charm.
Thank you for the suggestion
and your assistance.

> What happens if you use the Zoom tool before Copy As Picture?
> Download a 30-day trial of SnagIt (www.snagit.com takes you the TechSmith
[quoted text clipped - 45 lines]
>>>>
>>>> Any ideas?

Reply to this Message

GSalisbury - 24 Oct 2007 00:26 GMT

> Bernard,
>
[quoted text clipped - 41 lines]
> >>
> >> Any ideas?

You could try:
opening and sizing your source;
then an Alt/Print Screen;
then run an "imaging" pgm (mspaint?) and paste and sizing some more (if
necessary);
then a copy and paste into Word.
Repeat imaging/copy/paste if not quite right.
Maybe you'll have to have a Word Page as landscape.
Don't know fully what you have but it might work.
Geo. S.

Reply to this Message