Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy excel into word, rotate table 90 left, maintain formatting
Creating 9x6 Word2003 book. Need excel worksheet placed sideways into that
page size. |
#2
|
|||
|
|||
Bob was telling us:
Bob nous racontait que : Creating 9x6 Word2003 book. Need excel worksheet placed sideways into that page size. ....and with which part of the process are you having difficulties? -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#3
|
|||
|
|||
Unable to rotate text box in Word2003. Copy and Paste into Word with data
only creates a page that overflows to right, and is unreadable. Rotate unavailable in Word, if text box and linked boxes created. Was able to create text boxes with links, re-oriented text [bottom-up], but pasting data removed all formatting, and spreadsheet header data. "Jean-Guy Marcil" wrote: Bob was telling us: Bob nous racontait que : Creating 9x6 Word2003 book. Need excel worksheet placed sideways into that page size. ....and with which part of the process are you having difficulties? -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#4
|
|||
|
|||
Bob was telling us:
Bob nous racontait que : Unable to rotate text box in Word2003. Copy and Paste into Word with data only creates a page that overflows to right, and is unreadable. Rotate unavailable in Word, if text box and linked boxes created. Was able to create text boxes with links, re-oriented text [bottom-up], but pasting data removed all formatting, and spreadsheet header data. If you paste data from Excel, you need to use Paste Special from the Edit menu. Then, if you do not need a linked object, use any of the Picture format, if you need a linked object, use the Bitmap format. Finally, make sure that the pasted object is not inline with the text and then you will be able to rotate it. If all this is too much trouble, why not create a page that is 6x9 instead of 9x6? -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#5
|
|||
|
|||
Okay - Paste Special, using picture format = That works, but very small type,
and header is lost. Paste places whole spreadsheet, which is really 3 pages long onto one page, very small type (maybe 4). Rotating works, but font size does not change, and last 2 pages off page. "Jean-Guy Marcil" wrote: Bob was telling us: Bob nous racontait que : Unable to rotate text box in Word2003. Copy and Paste into Word with data only creates a page that overflows to right, and is unreadable. Rotate unavailable in Word, if text box and linked boxes created. Was able to create text boxes with links, re-oriented text [bottom-up], but pasting data removed all formatting, and spreadsheet header data. If you paste data from Excel, you need to use Paste Special from the Edit menu. Then, if you do not need a linked object, use any of the Picture format, if you need a linked object, use the Bitmap format. Finally, make sure that the pasted object is not inline with the text and then you will be able to rotate it. If all this is too much trouble, why not create a page that is 6x9 instead of 9x6? -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#6
|
|||
|
|||
Bob was telling us:
Bob nous racontait que : Okay - Paste Special, using picture format = That works, but very small type, and header is lost. Paste places whole spreadsheet, I do not think you can copy/paste a spreadsheet AND include the Excel header at the same time. I have never seen it done. You should probably ask in an Excel group (unless someone here knows how to do this) about this (and, if they tell you it is possible, please, report back here!) which is really 3 pages long onto one page, very small type (maybe How can you put a spreadsheet worth 3 pages on a 9x6 page? If it is too big, all you can do is reduce the pasted object so that it fits. A pasted object cannot overflow on to another page. If you must do that, divide your spreadsheet in three areas, and do 3 paste actions. 4). Rotating works, but font size does not change, and last 2 pages off page. Please, it would help if you wrote complete sentences... Sometimes, if we guess the missing words, we can get it wrong., and consequently give inappropriate advice, thereby wasting everybody's time. Do not forget that everybody involved here is a volunteer... -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#7
|
|||
|
|||
Change page size to 9x6 causes two problems. Page number footer also changes
to the 9 size (right side on book). Headers also missing, and data overflows to bottom. "Jean-Guy Marcil" wrote: Bob was telling us: Bob nous racontait que : Unable to rotate text box in Word2003. Copy and Paste into Word with data only creates a page that overflows to right, and is unreadable. Rotate unavailable in Word, if text box and linked boxes created. Was able to create text boxes with links, re-oriented text [bottom-up], but pasting data removed all formatting, and spreadsheet header data. If you paste data from Excel, you need to use Paste Special from the Edit menu. Then, if you do not need a linked object, use any of the Picture format, if you need a linked object, use the Bitmap format. Finally, make sure that the pasted object is not inline with the text and then you will be able to rotate it. If all this is too much trouble, why not create a page that is 6x9 instead of 9x6? -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#8
|
|||
|
|||
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. Creating text box, and rotating text left 90 fails because paste only allows unformatted text, spreadsheet headers are lost. 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. Special Paste (any picture format) fails, because picture reduces the three page spreadsheet to very small font (maybe 4). Outputting spreadsheet into three pages on pdf, and pasting each page seperately creates a fuzzy look, even at 600 dpi. Any other possibilities? Thanks, Bob "Jean-Guy Marcil" wrote: Bob was telling us: Bob nous racontait que : Okay - Paste Special, using picture format = That works, but very small type, and header is lost. Paste places whole spreadsheet, I do not think you can copy/paste a spreadsheet AND include the Excel header at the same time. I have never seen it done. You should probably ask in an Excel group (unless someone here knows how to do this) about this (and, if they tell you it is possible, please, report back here!) which is really 3 pages long onto one page, very small type (maybe How can you put a spreadsheet worth 3 pages on a 9x6 page? If it is too big, all you can do is reduce the pasted object so that it fits. A pasted object cannot overflow on to another page. If you must do that, divide your spreadsheet in three areas, and do 3 paste actions. 4). Rotating works, but font size does not change, and last 2 pages off page. Please, it would help if you wrote complete sentences... Sometimes, if we guess the missing words, we can get it wrong., and consequently give inappropriate advice, thereby wasting everybody's time. Do not forget that everybody involved here is a volunteer... -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
If you really want the page header from Excel, you can create a PDF of
the page from Excel, then export the page from Acrobat to EPS or TIFF, etc. That will give you a graphic of the entire page, with good resolution. If you don't have Acrobat, then there are alternatives. You may wish to re-examine the need for the Excel header. Obviously, when you cram an entire page from Excel into a Word page, things (including text) may get scaled down. Maybe that page needs to be a foldout, sized for the spreadsheet you're trying to display? |
#11
|
|||
|
|||
If you put a section break (next page) before and after the part where you
want the landscape pages you can turn off the page numbering in that section so you don't get any numbers at all, you can then restart the numbering after the last section break. Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com "Bob" wrote: Change page size to 9x6 causes two problems. Page number footer also changes to the 9 size (right side on book). Headers also missing, and data overflows to bottom. "Jean-Guy Marcil" wrote: Bob was telling us: Bob nous racontait que : Unable to rotate text box in Word2003. Copy and Paste into Word with data only creates a page that overflows to right, and is unreadable. Rotate unavailable in Word, if text box and linked boxes created. Was able to create text boxes with links, re-oriented text [bottom-up], but pasting data removed all formatting, and spreadsheet header data. If you paste data from Excel, you need to use Paste Special from the Edit menu. Then, if you do not need a linked object, use any of the Picture format, if you need a linked object, use the Bitmap format. Finally, make sure that the pasted object is not inline with the text and then you will be able to rotate it. If all this is too much trouble, why not create a page that is 6x9 instead of 9x6? -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#12
|
|||
|
|||
Andrea Jones was telling us:
Andrea Jones nous racontait que : If you put a section break (next page) before and after the part where you want the landscape pages you can turn off the page numbering in that section so you don't get any numbers at all, you can then restart the numbering after the last section break. If you had read the whole thread you might have noticed that the OP wanted to preserve the headers/footers as they were, this is why he did not opt for a landscape page, not because he did not know how or had trouble with numbering. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#13
|
|||
|
|||
oh- multi page:
each page would become seperate graphic. Lousy solution, but I don't know a better one- If you find something, please post it back here! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros - Keyboard Commands | Microsoft Word Help | |||
1st word in heading flush left second word flush right | New Users | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
Excel worksheet in Word linked text boxes | Page Layout |