I have spreadsheet data in a table that is larger than an A4 sheet of paper and I need to get this into a Word report.
When I copy and paste into a landscape, rotated, Word document ,the result is the extreme margins are cut off where it will not fit onto the A4 sheet exactly. I have tried adjusting the size of the rows and columns of the source Excel sheet, but this is very fiddly and only by trial and error... and I have several "copies" to do. I have tried using the Word "autofit" tool without sucess - maybe I am not using it in the right way. I have tried embedding an Excel worksheet into Word and then copying in - no can do!
Is there an elegant way of copying Excel data so it "autofits" onto one page.
All suggestion gratefully received.