Paste Word into Excel-no floating

  • Thread starter Thread starter office user
  • Start date Start date
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
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill color floating menu 2
Wrong import of float data 2
Copy-Paste Chart into Word from Excel 2007 3
Floating Page Breaks 2
Alt codes 4
Importing Long Numbers as Text cells 1
Recording Macro's Mini Floating Toolbar 5
How do I scale down an Excel worksheet to a single Word page? 9

Back
Top