Hello.....

Thank you very much for your reply.

I understand the difference between Embeded and Linked, the problem I am
experiencing is the actual 'look' of the table when pasted into Word.

I don't want to create a link, it is simply an embeded object I have
produced, however, when in Excel, the table fits perfectly onto one page but
when it is pasted into Word, the formatting changes completely and only fits
only 2, even 3 pages?

I understand that in Excel, you have the 'scaling' function which allows you
to shrink the worksheet but is there not an equivalent to this in Word? I
have used the 'shrink to fit' option in Print Preview but even this says it
can't do it!! I have changed the font size down to 4 and it still doesn't
fit??

Any quick fixes for this??

Thanks.

Louise

"How to link or embed objects in Word" wrote:

Select your text in Excel. Copy. In Word, select Edit, Paste Special. Pick
from one of the two buttons at left: (1) Paste: Embeds the worksheet, or (2)
Paste link: links the worksheet, then select "Microsoft Office Excel
worksheet object" from the list, then OK.

So ... how do you know which choice to make, embedded or linked? Paste
gives you an embedded object which means that if the document is going to be
sent to another location, you do not have to send the Excel file. The Excel
document is part of Word now. Access the worksheet for changes by right
clicking on the link, then selecting "Worksheet object" then Open. Open
gives you full functionality of Excel menu bars. Edit allows you to make
minor changes without seeing the Excel toolbars; this choice is particularly
useful when row(s) or column(s) get hidden. Simply right click on the link,
select Worksheet Object, Edit. Drag the right margin or the bottom margin
till you see all the rows or columns.

Paste Special "links" your document - two separate documents. When Excel is
updated, your Word file will be automatically updated when you open your
document ... IF the default setting is still set, which is ... Tools,
Options, General, Update automatic links at open. If you send a linked Word
document to another party, you should inform them to turn this feature off.
The more links in a document the longer it takes to open with this feature
turned on.

Another tip ... use Alt + F9 to tell whether your links are embedded or
linked. The link is temporarily hidden. If the worksheet is embedded, you
will see the words "Embedded." If the worksheet is linked, it will begin
with the word "Link Excel Sheet 8, then you will see either your server name
or your hard drive path, then you will next see the Excel document name, then
the worksheet name, then you will see the number of rows and columns - two Rs
and two Cs. The second R & C is what you look at.

When you add a row or column, the link must be deleted and relinked. If the
worksheet is embedded, simply right click, as stated above, and choose Edit
and widen the right column or bottom margin. If the worksheet is linked,
when rows or columns are added, however many were added will cause that
number of rows or columns to be hidden in a buffer zone, i.e., if you added
two rows in Excel, the last two rows will go into a buffer zone and not be
seen in Word. Two options he delete and relink or use this helpful hint
I figured out years ago after being flustered at having delete and relink all
the time. Use Alt + F9, scroll through your document till you find your
link. If you have 39 rows in Excel and you added two, you now have 41 rows,
right. In Word under Alt + F9, change the 39 to a 41. Same goes for
columns, except note that column J is the same as 10, right. You simply
increase the columns shown in Alt+F9 by the number you have added. Select
Alt + F9 once again to return to your previous view. Select the link and F9.
F9 is the shortcut to updating a link (long way, Edit, Links, Update now).
You can update ALL links at the same time here. Simply choose Edit, Links,
select all the links in the list and then Update Now. Note that in the third
column, these should all say "Worksheet." If any of them say ExcelSheet8,
you MUST relink; there is a problem.

So ... here's your question answered and more.

"Louise" wrote:

Is there an easy way to insert an Excel worksheet into a Word document?

I have a Word document and want to import quite a large a table I have
created in Excel. I have tried Copy/Paste and Copy/Paste Special, however,
the size of the Excel table is altered quite drastically and physically will
not fit into the Word document, even though in Excel it is well withi the
parameters of an A4 piece of paper.

I have also used the Insert Excel Worksheet icon within Word and then pasted
my information into there, but the formatting changes and still doesn't fit
on to the paper.

What's the easiest way to do this?? Ive come across this problem loads of
times and can't find a solution.

Any urgent help would be much appreciated.

Thank you.

Louise