Tom’s Tutorials For Excel: Inserting a Word Document Onto Your Spreadsheet
Here are the simple steps for inserting a Word document directly onto your worksheet.
From the Ribbon, click the Insert tab and then click the Object icon.
If you are using Excel’s version 2003 or before, click Insert from the menu bar and click Object from the dropdown menu as shown here.
• In the Object dialog box, click the Create New tab.
• Scroll down to Word 2007 document, select it and click OK.
If you are using Excel’s version 2003 or before:
• In the Object dialog box click the Create New tab.
• Scroll down to Microsoft Word Document, select it and click OK.
That’s it! Just size your new embedded Word doc and type into it as you normally would.
Dear Tom, This is great.
I also watched your tweet to open a word doc. through a macro from excel.
Can you please make a similar macro to embed a word doc. into a spreadsheet, similar to what you have done manually in your post above?
Thanks for the suggestion. I’ll create one in a few weeks.