Thank you so much for the responses. I did paste as an Excel object because
there are formulas, and numbers I would like to have the capability of
changing with recalculation in the future. Is it possible to maintain an
interactive format and have the spreadsheet still expand to multiple pages?
Also, I selected a range to insert but the object is the entire spreadsheet
and multiple tabs. I broke each tab into a separate file, which is better.
However, I still can scroll down to blank lines and potentially just see
blank rows or columns in my Word document. Thanks again
"Stefan Blom" wrote:
Note that if you pasted as an Excel object, the behavior you are describing
is to be expected, since Word does not allow objects to extend across pages.
Instead, make sure to paste in RTF (table) format, if necessary via the
Paste Special dialog box (Home tab | Paste | Paste Special).
--
Stefan Blom
Microsoft Word MVP
"Tricia Butler" Tricia wrote in message
...
I have a spreadsheet that one and a half pages long. When I insert it into
Word, it cuts off after one page. Is it possible to have a spreadsheet
continue to multiple pages in Word?