Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying large spreadsheet into Word
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying large spreadsheet into Word
you can try doing a File/open in word, and it comes in as a table, but you do
lose the excel page setup stuff "JoeyG" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying large spreadsheet into Word
Yes - already tried that! I can't believe there's no way to keep the
formatting... Thanks anyway... "dlw" wrote: you can try doing a File/open in word, and it comes in as a table, but you do lose the excel page setup stuff "JoeyG" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying a large spreadsheet into Word | Excel Discussion (Misc queries) | |||
Copying Formatting - 'Selection Too Large' | Excel Discussion (Misc queries) | |||
Copying large number of sheets | Excel Discussion (Misc queries) | |||
Copying Formulas in LARGE Files | Excel Worksheet Functions | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |