Copying 200 default rows from excel print 74 only in word. Adjusting TOCto reflect page numbering 19.09.2006 20:35:01 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

Re: Copying 200 default rows from excel print 74 only in word. "Ed" <ed_millis[ at ]NO_SPAM.yahoo.com> 19.09.2006 22:01:52 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" <AdjustingTOCtoreflectpagenumbering[ at ]discussions.microsoft.com> wrote in message news:2F6CCFE5-F922-4D6A-AFFC-091BAD3E4561[ at ]microsoft.com... [Quoted Text] > 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

Re: Copying 200 default rows from excel print 74 only in word. Adjusting TOCto reflect page numbering 20.09.2006 00:27:01 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: [Quoted Text] > 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" > <AdjustingTOCtoreflectpagenumbering[ at ]discussions.microsoft.com> wrote in > message news:2F6CCFE5-F922-4D6A-AFFC-091BAD3E4561[ at ]microsoft.com... > > 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 > > >

Re: Copying 200 default rows from excel print 74 only in word. Jay Freedman <jay.freedman[ at ]verizon.net> 20.09.2006 02:28:21 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 <AdjustingTOCtoreflectpagenumbering[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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" >> <AdjustingTOCtoreflectpagenumbering[ at ]discussions.microsoft.com> wrote in >> message news:2F6CCFE5-F922-4D6A-AFFC-091BAD3E4561[ at ]microsoft.com... >> > 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 >> >> >>