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"
wrote in message
...

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