How can I paste an excel table that goes over two or more pages into word? (going also over two pages!) I know the usual method copy - paste special - enhanced metafile, but that is just with one page, then I usually hide the other lines and copy again. But there must be a better way, right?
The only way you will fit it in a word on single page is to scale it.
It will become difficult to read but not distorted.
Better alternative is to paste it as LINK in Word document.