Monday

Combine MS Word and MS Excel Spreadsheets into One Document

Quite often a user needs to create a presentation with both Word documents and Excel spreadsheets. There is an effective way to do this so that the presentation stays in order and contained within one document, which is helpful when printing or distributing the file electronically.

Create the text portion of the presentation using Microsoft Word. If the presentation consists of numerous ideas, it is OK to write them in separate documents. These separate documents will all be combined in the end. Be sure to spell check and then save the documents into their own folder for easy sorting. Also be sure to give a meaningful name to each file so that they will be easy to find. Sometimes it is a good idea to begin the name of each document with a number, for instance "001 - ideas.doc" and "002 - more ideas.doc", so that they may be easily kept in order.

Now, create the Excel spreadsheets. The same idea applies to these files. Save them into their own folder for easy sorting. It is a good idea to keep the Word documents and the Excel spreadsheets separate.  Create the "master" document using Microsoft Word by opening MS Word and selecting "new" and then "blank document." Assign a meaningful name to this document, like "Master.doc." Be sure the cursor is blinking in the open blank space at the top of the blank document and then select the "Insert" menu and then "Object." This will open the "object" window. Select the tab for "Create from File." Be sure the check box beside "Link to File" is selected. If not, select it before proceeding. Now, click the "Browse" button and navigate to the folder where you saved the MS Word document or the Excel spreadsheet that you would like to use to begin the presentation. Select the file and press the "insert" button. Repeat this procedure as many times as necessary to compile a complete presentation consisting of both MS Word and Excel files.

When the "Master Document" is complete, be sure to save it. If changes should be made to any of the individual files, they may be done by opening the master document, double-clicking the section that needs to be changed, making the changes, and saving the file.  Do not delete the original MS Word documents or Excel spreadsheets! The "Master Document" is only linked to these files.

Related articles
How to fix the "C:\Documents.xls' could not be found." error in MS Excel
How to Make QuickBooks Run Faster

No comments: