Sigh. I have to do this all the time…
But needn’t take sooo long once you get the hang of it:
– select cells to copy. Make sure you’ve got all of them.
– paste into word. The columns will probably disappear off the page, so
– select View –> online layout
– you can see all the columns now. Resize them until they’ll all fit on one page. (This is probably narrower than you think)
– switch back to normal view (I think it’s called page layout, or similar)
– drag the columns until they all fit nicely on the page.
– If some bastard has put merged cells in there, kill them, it will ruin everything
And if you’re fussy like me:
– select the whole table –> “table properties”, untick “allow row to break across pages”
– select the header row (if you have one) –> table properties, tick “repeat as header row on each page”
– … and you’re done. Sit quietly for a moment and wonder what it must be like to have a proper job.
Final points:
– Yes, the company I work for has shit software & processes. So did the last one
– I can’t believe I was excited to open this thread, hoping some boffin knows a quick, simple, & idiot-proof way of automating all this.
– If you are that boffin, may the heavens rain down radiant jewels and sweetmeats upon you.