Share via

How to insert a Word document into Excel and still keep the formatting

Anonymous
2013-07-24T17:20:34+00:00

I have been tasked with combining a number of .pdf and Word documents into Excel spreadsheets. Ultimately, they want to be able to view the entire document (.pdf or .doc) as if was opened with the original program (i.e.: Acrobat or Word) without having to actually open the other program. I have searched the internet and found how to add objects and pictures (.jpg, .tiff, .bmp, etc), but these only show one page and you have to either double-click to open another program or scroll through the embedded window.

Problem is to add the Word document to the Excel spreadsheet and not have to continually re-format the file. I have about 100 Word documents with varying amounts of pages (many up to ten) and varying tab/column spacing; so trying to "embed" single pages will take too much time.  Additionally, since these Excel files will be distributed to others that do not have access to the original files, "linking" to them is not a viable option.

At work we are running MS Office 2010 and 2000 and I have Office 2003 at home, if any of these will make a difference. Preferred, is Office 2010.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-07-25T12:14:12+00:00

    Hi,

    When you insert a file as object it only show one page and you have to either double-click to open another program or scroll through the embedded window this is by default you would not be able to change it.

    If you embed a file without selecting any option like ‘Link to file’ or ‘Display as icon’ it would embed the file directly on the computer and when you do any changes to the embedded file by default it would not affect the main file.

    I hope the above information helps. Let us know if you need further assistance.

    Thank you.

    5 people found this answer helpful.
    0 comments