XL2K Truncates RH column when pasted into Word 2K 1

[MeGustaXL]

HI there,

My XLS has columns A to AX, and about 500 rows.

I want to copy columns A to L, about 10 rows at a time, and paste them into Word on a landscape page.

If I just Copy & Paste, the result is a Table that's way too big to fit on one page, and I can't figure out how to resize it easily.

SO I try pasting as a picture. This starts out way too wide, but I can resize it to about 60% height, keep the aspect ratio, and reposition on the page - GREAT, except column L is missing!

Copy A to K - Paste as Picture - PerfectaMundo!

Shift Copy, Save as Picture > "The picture is too large and will be truncated" Nooooo!

A. I simply must have all these columns
B. It must fit on a landscape A4 page.
C. It mustn't bloat the document too much, so embedding the worksheet isn't an option - it's GIGANTIC.

Any hints, tips or links to FAQs on this subject?

Chris

I went to a shop to buy a watch. The bloke said "Analogue?" I said "No thanks, just the watch!" - Tommy Cooper

 

[25061959]

Highlight the columns you want to use and when you go to Word use Paste Special - Unformatted text, you will then get the columns with tabs inbetween, you can then choose to convert text to table using tabs.

Hope this helps.

 

[MeGustaXL]

Genius! Have a STAR 25061959, and Happy Birthday in June!