Office 2000 pasting multiple excel pages into Word-

  • Thread starter Thread starter woodis
  • Start date Start date
W

woodis

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
 
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.
 
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
 
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.
 
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 said:
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 said:
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.
Click to expand...

.
Click to expand...
 
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.
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



woodis said:
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 said:
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 said:
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.

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
Click to expand...

.
Click to expand...
Click to expand...
 
Back
Top