If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel imports into Word
I produce several large reports each year, and to this
point, its all done in Word. I imbed Excel charts and spreadsheets into this Word document, which works fine except when I have some Excel spreadsheets that need to be rotated 90 degrees into a landscape orientation. I cannot see how to rotate those spreadsheets, and it requires me to manually produce that page and insert it into the print job. The questions I have a is there any way to put an Excel spreadsheet into a word document and rotate it to fit? Also, on two occasions, on a large, one page Excel spreadsheet, that spreadsheet cannot be imported into the Word document without losing lines, and I cannot resize it to fit. Am I exceeding the ability of Word and is there other software that putting this all into would work better? I'd sure like to be able to have this all as one single file, put it on a CD and take it to our print shop, with the simple request of "print 500 copies of this" instead of having to have detailed explanations of what to print separately and hand insert. Thanks. |
#2
|
|||
|
|||
Excel imports into Word
Hi, Lee.
If you are pasting the Excel spreadsheets into Word as Excel objects, then you cannot rotate them. Instead, you can create a landscape page in your otherwise-portrait Word document (see item 1 in http://word.mvps.org/faqs/formatting...apeSection.htm), then insert your Excel object into the landscape page. If you are pasting as pictures or enhanced metafiles, then it is possible to rotate them by formatting them as NOT inline-with-text (right-click on the picture, left-click on Format Picture | Layout | select a wrapping option other than inline-with-text), then using one of the rotate buttons or the rotate command from the Drawing toolbar. There is a limit to how many rows/columns you can paste from Excel into Word. This limit is not an exact number of rows or columns. Instead, the limit is the number of rows or columns can fit with a maximum reduction of 69% of original size. If you select an Excel range that has to be shrunk more than 69% to fit within the margins of the Word page, then the pasted image will be shrunk to 69%, and any columns/rows that don't fit will be truncated. If you have a large Excel range that you need to paste into Word, it may be necessary to copy and paste it in two or more parts. Lee wrote: I produce several large reports each year, and to this point, its all done in Word. I imbed Excel charts and spreadsheets into this Word document, which works fine except when I have some Excel spreadsheets that need to be rotated 90 degrees into a landscape orientation. I cannot see how to rotate those spreadsheets, and it requires me to manually produce that page and insert it into the print job. The questions I have a is there any way to put an Excel spreadsheet into a word document and rotate it to fit? Also, on two occasions, on a large, one page Excel spreadsheet, that spreadsheet cannot be imported into the Word document without losing lines, and I cannot resize it to fit. Am I exceeding the ability of Word and is there other software that putting this all into would work better? I'd sure like to be able to have this all as one single file, put it on a CD and take it to our print shop, with the simple request of "print 500 copies of this" instead of having to have detailed explanations of what to print separately and hand insert. Thanks. |
#3
|
|||
|
|||
Excel imports into Word
Hi, Lee.
If you are pasting the Excel spreadsheets into Word as Excel objects, then you cannot rotate them. Instead, you can create a landscape page in your otherwise-portrait Word document (see item 1 in http://word.mvps.org/faqs/formatting...apeSection.htm), then insert your Excel object into the landscape page. If you are pasting as pictures or enhanced metafiles, then it is possible to rotate them by formatting them as NOT inline-with-text (right-click on the picture, left-click on Format Picture | Layout | select a wrapping option other than inline-with-text), then using one of the rotate buttons or the rotate command from the Drawing toolbar. There is a limit to how many rows/columns you can paste from Excel into Word. This limit is not an exact number of rows or columns. Instead, the limit is the number of rows or columns can fit with a maximum reduction of 69% of original size. If you select an Excel range that has to be shrunk more than 69% to fit within the margins of the Word page, then the pasted image will be shrunk to 69%, and any columns/rows that don't fit will be truncated. If you have a large Excel range that you need to paste into Word, it may be necessary to copy and paste it in two or more parts. Lee wrote: I produce several large reports each year, and to this point, its all done in Word. I imbed Excel charts and spreadsheets into this Word document, which works fine except when I have some Excel spreadsheets that need to be rotated 90 degrees into a landscape orientation. I cannot see how to rotate those spreadsheets, and it requires me to manually produce that page and insert it into the print job. The questions I have a is there any way to put an Excel spreadsheet into a word document and rotate it to fit? Also, on two occasions, on a large, one page Excel spreadsheet, that spreadsheet cannot be imported into the Word document without losing lines, and I cannot resize it to fit. Am I exceeding the ability of Word and is there other software that putting this all into would work better? I'd sure like to be able to have this all as one single file, put it on a CD and take it to our print shop, with the simple request of "print 500 copies of this" instead of having to have detailed explanations of what to print separately and hand insert. Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking data from Excel to Word | Kolja | General Discussion | 1 | June 9th, 2004 08:17 PM |
Excel Table into a Word Doc | Kevin | Worksheet Functions | 2 | May 6th, 2004 08:27 PM |
word error | mac | General Discussions | 1 | May 6th, 2004 08:14 AM |
Save As and changing file names in Word 2000 | Gene Goldenfeld | New Users | 11 | May 5th, 2004 04:08 AM |
Word To Excel Links | Chris \( Val \) | Links and Linking | 4 | April 24th, 2004 07:48 AM |