Paste Word into Excel-no floating

O

office user

Is there a way to paste a Word Document into Excel so it doesn't float around
the page? Word and Excel 2003
 
K

Kevin B

After you've inserted the Word document object, right click on the object and
select
FORMAT OBJECT from the popup menu.

Click the properties tab and click the option button DON'T MOVE OR SIZE WITH
CELLS

This anchors the object at the current position in the workbook.
 
K

Kevin B

Moves in what way? If it's selected and you click and drag the object
somewhere it will move, regardless of property settings.

You could lock the object in place, but it would require that you format the
worksheet by indicating what cells are unprotected (so you can enter data
into them) and which cells are protected and then turn protection on for the
worksheet the Word document is in. Password would be optional
 
Top