I've formatted my data so it looks how I want in the Print Preview (8 pages,
column headers on every page etc), but can't copy that over into Word. Copy
and paste loses all the formatting, while saving it as an image means that it
pastes onto a single page, way too small to read. I've tried making a .pdf
but it's coming out all shaded and illegible (even though I haven't put a
fill colour in my cells).

Can anyone help?