Paste from EXCEL into WORD when reduced

[vishthefish]

Hi there

I am trying to paste from WORD into EXCEL.

The Excel spreadsheet is big -- on page options I have to reduce the view of 15% to fit it on one page.

I wish to paste it, exactly as it appears at 15%, into MS WORD but cannot. When I try it pastes at FULL size not the reduced 15%. If I paste special none of the formats work (metafile, bmp, html, picture). If I import it as an object it doesn't work either.

Any ideas?

Regards

Vishthefish

[Anne Troy]

Try this:
Select the cells you want.
From the Zoom dropdown, choose Selection.
Then save the file. Then copy....

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"vishthefish" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi there
>
> I am trying to paste from WORD into EXCEL.
>
> The Excel spreadsheet is big -- on page options I have to reduce the
> view of 15% to fit it on one page.
>
> I wish to paste it, exactly as it appears at 15%, into MS WORD but
> cannot. When I try it pastes at FULL size not the reduced 15%. If I
> paste special none of the formats work (metafile, bmp, html, picture).
> If I import it as an object it doesn't work either.
>
> Any ideas?
>
> Regards
>
> Vishthefish
>
>
> --
> vishthefish
> ------------------------------------------------------------------------
> vishthefish's Profile:
> http://www.excelforum.com/member.php...o&userid=31400
> View this thread: http://www.excelforum.com/showthread...hreadid=510984
>