View Single Post
  #9   Report Post  
Jean-Guy Marcil
 
Posts: n/a
Default

Bob was telling us:
Bob nous racontait que :

Excel spreadsheet is three pages long, 16 x 91 cells, header is three
lines.

Word document will be 6x9, with a page number footer.

Since the spreadsheet is so wide, traditionally these spreadsheets
have been printed, and scanned into camera ready material, and the
printer inserts this hardcopy into printer layouts.

I was hoping to copy spreadsheet into Word document, and get the same
output as printing spreadsheet does, three page long (landscape),
with header.

Creating a new Word section, with page 9x6 fails. Header is lost,
and page number footer in Word rotates to right side of page.

Creating a text box, and pasting into text box fails because data
overflows to right, and rotate is not available with text box.


Are you saying that with this method the Excel header was pasted along with
the spreadsheet? How did you do it?

Creating text box, and rotating text left 90 fails because paste only
allows unformatted text, spreadsheet headers are lost.


Excel header lost, as expected.

Creating text boxes with link-text fails, because paste of data
removes excel headers, and formats as text, removing the right
justification of each column.


Excel header lost, as expected.

Special Paste (any picture format) fails, because picture reduces the
three page spreadsheet to very small font (maybe 4).


Excel header?


Outputting spreadsheet into three pages on pdf, and pasting each page
seperately creates a fuzzy look, even at 600 dpi.

Any other possibilities?


As I wrote in an earlier reply:

"divide your spreadsheet in three areas, and do 3 paste actions"

i.e., select one third of the spreadsheet, copy/paste, add a page in Word,
come back, select the second third, etc.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org