Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Copying 200 default rows from excel print 74 only in word.
Hi,
When I Copy (all) my 200 rows from Excel and paste them as picture into Word, Word prints the first 74 rows only. The rest of the 200 rows disappear from Word!! When I however use copy picture at Ecxel(with shift/edit), I can paste the whole 200 rows but all appear very compressed in one page of word (tiny font). Is there a possibility to copy the 200 rows 1-to-1, i.e. the 200 rows print in one ore more pages of Word with loosing current format? Thanks |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Copying 200 default rows from excel print 74 only in word.
Why do you paste as picture? Why not paste it in as a table? It's
apparently too big to fit on a single Word page at your margin settings. If you let it become a table, it will flow over onto the next page. Ed "Adjusting TOCto reflect page numbering" crosoft.com wrote in message ... Hi, When I Copy (all) my 200 rows from Excel and paste them as picture into Word, Word prints the first 74 rows only. The rest of the 200 rows disappear from Word!! When I however use copy picture at Ecxel(with shift/edit), I can paste the whole 200 rows but all appear very compressed in one page of word (tiny font). Is there a possibility to copy the 200 rows 1-to-1, i.e. the 200 rows in one ore more pages of Word with loosing current format? Thanks |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Copying 200 default rows from excel print 74 only in word.
Hi Ed,
Thanks for the reply. I paste as a picture because I want the preadsheet listing to include the Excel row numbers as well, so that the target reader can follow up my math calculations and row referrals. Pasting in as a table will not include the row numbers. Again word pastes only 74 rows and ignores the rest. Do you know about this magic number? How can I paste into word including the row numbers and still get the spreadsheet overflow to cover next pages? Thanks and greeting from Germany. Kalid "Ed" wrote: Why do you paste as picture? Why not paste it in as a table? It's apparently too big to fit on a single Word page at your margin settings. If you let it become a table, it will flow over onto the next page. Ed "Adjusting TOCto reflect page numbering" crosoft.com wrote in message ... Hi, When I Copy (all) my 200 rows from Excel and paste them as picture into Word, Word prints the first 74 rows only. The rest of the 200 rows disappear from Word!! When I however use copy picture at Ecxel(with shift/edit), I can paste the whole 200 rows but all appear very compressed in one page of word (tiny font). Is there a possibility to copy the 200 rows 1-to-1, i.e. the 200 rows in one ore more pages of Word with loosing current format? Thanks |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Copying 200 default rows from excel print 74 only in word.
When you paste as a picture, you're getting an object. In Word,
objects can't cross a page boundary. There's no way around that. The rest of the picture is in the object, but Word can't display it. One workaround is to select only as much in Excel as you know will fit on a Word page, paste that into Word, and go back to Excel for the next part. Repeat until you have all the pieces. Another possibility is to add another column in Excel and fill it with a series, so it matches the row numbers. Then copy and paste as text to get a Word table, and format the row number column to look the way you want. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Tue, 19 Sep 2006 17:27:01 -0700, Adjusting TOCto reflect page numbering crosoft.com wrote: Hi Ed, Thanks for the reply. I paste as a picture because I want the preadsheet listing to include the Excel row numbers as well, so that the target reader can follow up my math calculations and row referrals. Pasting in as a table will not include the row numbers. Again word pastes only 74 rows and ignores the rest. Do you know about this magic number? How can I paste into word including the row numbers and still get the spreadsheet overflow to cover next pages? Thanks and greeting from Germany. Kalid "Ed" wrote: Why do you paste as picture? Why not paste it in as a table? It's apparently too big to fit on a single Word page at your margin settings. If you let it become a table, it will flow over onto the next page. Ed "Adjusting TOCto reflect page numbering" crosoft.com wrote in message ... Hi, When I Copy (all) my 200 rows from Excel and paste them as picture into Word, Word prints the first 74 rows only. The rest of the 200 rows disappear from Word!! When I however use copy picture at Ecxel(with shift/edit), I can paste the whole 200 rows but all appear very compressed in one page of word (tiny font). Is there a possibility to copy the 200 rows 1-to-1, i.e. the 200 rows in one ore more pages of Word with loosing current format? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Linking Text from Excel to Word | Microsoft Word Help | |||
I am having difficulty with deleting headers and footers | New Users | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout | |||
Excel worksheet in Word linked text boxes | Page Layout |