Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to insert Excel tables into Word documents

0 views
Skip to first unread message

laur...@shaw.ca

unread,
Apr 6, 2002, 12:03:13 PM4/6/02
to
I used to have to do a Word report with several Excel spreadsheets so I used;
Insert
Object
Clicked on the Tab "Create from File"
Choose the Spreadsheet I wanted to use and it would insert into Word but only
like a partial table...then I double clicked on the table and it went right
into the Excel file so that I could enlarge, adjust rows, pick the rows the
rows I needed, change formulas, etc. etc.

I wouldn't say it was an easy process but I was able to do what I wanted.
Laurie

On 3/31/02 10:26AM, in message <O79#6CO2BHA.2112@tkmsftngp02>, "Blissier"
<blis...@hetnet.nl> wrote:

> Does anyone know how to insert Excel tables into Word.
> I am writing scientific reports. I use Word as text editor and Excel (office
> 2000)as spreadsheet.
> I want to insert several Excel tables into one Word document.
>
> Each Excel sheet has about 15 tables.
> Some of the tables does not fit on one page.
> In Excel you can choose "fit to page".
> However after selecting "fit to page" the right part of the table is not
> inserted in the Word document.
>
> If I "select and Copy" one table(in Excel) and use "Paste - ctrl V) in Word
> then only part of the table is included into the Word document.
>
> If I "select and Copy" one table(in Excel) and use "Paste special" and
> choose
> "Object" than the whole sheet is incorperated in the Word document.
> Unfortunately it is not possible to use more then one page using the
> "Object" item.
>
> Does anyone knows how to insert Excel data into Word documents in an easy
> way.
>
> Thank you
> Blissier
>
>


0 new messages