Inserting Excel Worksheet in Word Document

[Guest]

I am writing a report and have inserted a matrix using Excel into a Word document. I was told that there is such a thing as "Lock Anchors" that I can enable so that the worksheet will not move while I write the rest of the report. I have been unsuccessful in finding this feature. Can someone help me?

 

[Jay Freedman]

Right-click the inserted section of worksheet and click Format Object.
In the resulting dialog, click the Layout tab, and then click the
Advanced button. The Lock Anchor checkbox is in the lower left quarter
of the dialog.

This setting doesn't lock the worksheet in one place permanently -- it
can still move from one page to another. You have to understand what
Word means by an "anchor": The object (in your case a worksheet, but
it could be a picture or a drawing shape) is attached to a particular
paragraph in the text. If you turn on the Object Anchors option in
Tools > Options > View, you can see an anchor icon in the left margin
next to that paragraph whenever the object is selected. If editing
causes the paragraph to go onto a different page, the object will move
with it -- the object and its anchor can never be on different pages.

In the Format Object > Layout > Advanced dialog, you should change the
vertical position to absolute position relative to the page or margin,
rather than relative to the paragraph (the one that contains the
anchor). If you leave the setting relative to the paragraph, the
worksheet will move up and down the page if the paragraph moves.

When the anchor icon is displayed, you can grab it with the mouse and
drag it to another paragraph. You may want to do this intentionally,
but you may want to avoid doing it by accident. The only thing that
the Lock Anchor setting does is to prevent the anchor from
accidentally being dragged from one paragraph to another.

 

[Jezebel]

Select the embedded worksheet, then go to tools > Options > View to switch
on the display of anchors. It appears as a little ship's anchor in the left
margin, alongside the paragraph to which the object is anchored (this
applies to any graphic object, btw). Normally Word moves the anchor to the
nearest paragraph, and the object is positioned relative to that paragraph,
so if the paragraph moves, so does the object. (And if you delete the
paragraph, you delete the object also.)

There are two issues with positioning: 1) you can drag the anchor itself to
select the paragraph to which the object is anchored. If you want the object
to stay in a fixed position, it's often simplest to anchor it to the
heading. 2) you can specify that the object be positioned relative to the
page rather than the paragraph. For both of these, right-click the object,
select properties from the popup menu, go to Layout > Advanced. Experiment
with the options.

Locking the anchor fixes the paragraph to which the object is anchored: this
doesn't in itself fix the object's position. It only guarantees that the
object will be on the same page as that paragraph.

I am writing a report and have inserted a matrix using Excel into a Word

document. I was told that there is such a thing as "Lock Anchors" that I can
enable so that the worksheet will not move while I write the rest of the
report. I have been unsuccessful in finding this feature. Can someone help
me?