Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default merging documents,exporting long landscape table to word with page breaks & numbers

Further thoughts:

If you do <ALT<PrintScreen you copy a "picture" of the current window
to the clipboard, which can then be pasted into Word. So, if you can
arrange your Excel window to display the part of the table which you
want to see on one page, this may be one way to achieve what you want.
You can hide the scroll bars and row/column identifiers in Excel
beforehand, or you can crop these from the image in Word, where you
might be able to rotate the image to get landscape orientation
(although I couldn't rotate a small image when I tried just now).

This would be a bit tedious if you have 37 pages, as you would
obviously have to repeat this for each page, but it is possibly another
way to do what you want.

Hope this helps.

Pete

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
excel table in a page of a word document, horizontally AC Excel Discussion (Misc queries) 1 May 16th 05 09:21 AM
paste excel table to word Stephen Excel Worksheet Functions 1 January 23rd 05 03:27 PM
Paste table from excel to word Stephen Excel Worksheet Functions 0 January 22nd 05 11:15 AM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"