Prev: How do I edit the Current Multilevel List in Word 2007??
Next: select a pattern
From: woodis on 16 Dec 2009 17:16
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: Doug Robbins - Word MVP on 16 Dec 2009 17:57
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: macropod on 16 Dec 2009 23:38
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
>

From: woodis on 17 Dec 2009 15:49
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: woodis on 17 Dec 2009 15:53
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
> >
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: How do I edit the Current Multilevel List in Word 2007??
Next: select a pattern