Prev: How do I edit the Current Multilevel List in Word 2007??
Next: select a pattern
From: Doug Robbins - Word MVP on 17 Dec 2009 18:32
Using the SnagIt printer (Get SnagIt from www.techsmith.com), that task is
quite simple

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"woodis" <woodis(a)discussions.microsoft.com> wrote in message
news:1FED864A-617E-4251-8F95-06D74FF1142F(a)microsoft.com...
> Thanks Doug. This works but its not really not what I need. Too many
> formatting problems. Gonna print to pdf, then save as a tiff, then insert
> into word.
>
> Appreciate your response.
>
> "Doug Robbins - Word MVP" wrote:
>
>> As you say the Excel data is breaking across pages, I assume that you are
>> pasting the cells into word using a simple paste, in which case it is
>> actually being converted to a Word table so that you can use Word's
>> Heading
>> Rows Repeat facility to get the top four row to repeat on each page.
>>
>> --
>> Hope this helps,
>>
>> Doug Robbins - Word MVP
>>
>> Please reply only to the newsgroups unless you wish to obtain my services
>> on
>> a paid professional basis.
>>
>> "woodis" <woodis(a)discussions.microsoft.com> wrote in message
>> news:828CF4C7-56A8-4B30-8480-C29A81E107F3(a)microsoft.com...
>> > Hi Folks,
>> >
>> > Per the subject, I have an excel file with 400 plus rows of data, and
>> > the
>> > page setup is set to repeat four rows at the top of each page when
>> > printed.
>> > Is there any way to paste the rows into Word so that it retains the
>> > "repeat
>> > the rows at top of every page" when it breaks across the pages in Word?
>> > If
>> > there is I have not found a way.
>> >
>> > Thanks
>>

From: Graham Mayor on 18 Dec 2009 01:22
You are obviously aware that objects in Word cannot span pages, but if you
select a suitably sized portion of your spreadsheet that will fit on a page
and copy to the clipboard then in Word Edit > Paste Special > Bitmap - check
the link box, the clipboard content is inserted as a bitmapped image which
can be scaled to fit your page, and which remains linked to the sheet so
that it will reflect changes. The bitmap will also retain its inserted size.
Repeat for the other 'pages'.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



"woodis" <woodis(a)discussions.microsoft.com> wrote in message
news:733438A4-BB94-46C4-9664-A2FAEE392284(a)microsoft.com...
> Thanks for the reply macropod. Ive been trying to solve this problem for
> years, huge spreadsheets all formatted just right, then try to bring them
> into word is a problem. The best way I have found to to this is a
> cumbersome
> way but it works. Print excel file to pdf. Save as tiff. Each page
> retains
> formatting needed. Then paste the picture into word. Gotta be a better
> way.
>
> Thanks again for the info, it works well on smaller tables.
>
> "macropod" wrote:
>
>> If, however, you're using Edit|Paste Special with the 'Paste Link'option,
>> you need to do something along the lines of:
>> a. paste the Excel 'heading' rows into the page header, then paste the
>> remaining Excel rows into the document body; or
>> b. create a two-row table, the first of which you format as 'heading rows
>> repeat', then paste the Excel 'heading' rows into the
>> first row of the table, and the remaining Excel rows into the second row
>> of the table
>>
>> --
>> Cheers
>> macropod
>> [Microsoft MVP - Word]
>>
>>
>> "Doug Robbins - Word MVP" <dkr(a)REMOVECAPSmvps.org> wrote in message
>> news:6FC621DE-000B-4E6D-A001-315F140AF483(a)microsoft.com...
>> > As you say the Excel data is breaking across pages, I assume that you
>> > are pasting the cells into word using a simple paste, in
>> > which case it is actually being converted to a Word table so that you
>> > can use Word's Heading Rows Repeat facility to get the top
>> > four row to repeat on each page.
>> >
>> > --
>> > Hope this helps,
>> >
>> > Doug Robbins - Word MVP
>> >
>> > Please reply only to the newsgroups unless you wish to obtain my
>> > services on
>> > a paid professional basis.
>> >
>> > "woodis" <woodis(a)discussions.microsoft.com> wrote in message
>> > news:828CF4C7-56A8-4B30-8480-C29A81E107F3(a)microsoft.com...
>> >> Hi Folks,
>> >>
>> >> Per the subject, I have an excel file with 400 plus rows of data, and
>> >> the
>> >> page setup is set to repeat four rows at the top of each page when
>> >> printed.
>> >> Is there any way to paste the rows into Word so that it retains the
>> >> "repeat
>> >> the rows at top of every page" when it breaks across the pages in
>> >> Word? If
>> >> there is I have not found a way.
>> >>
>> >> Thanks
>> >
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: How do I edit the Current Multilevel List in Word 2007??
Next: select a pattern