![]() Double-clicking on the document opens it for editing inside the source application.Single-clicking on the document reveals resize handles to change the size of the document.We can simply drag and drop the Word document anywhere on the worksheet.Once the Word document is embedded, there are many edits we can make: This achieves the same result as using the Ribbon. Toggle the check box to decide whether to display the item as an icon.Microsoft Word Document Object in the As list.In the Paste Special dialog box, select:.Click Paste (drop down), then click Paste Special….Go back to the original Excel file, select the cell where the object is to be inserted.Copy the selection by clicking Home > Copy (or press Ctrl + C).With the word document open, select the text to be visible on the spreadsheet.Use this method for Word documents that are already open. The second easy way of embedding a Word document uses Paste Special. If you choose to display it as an icon, the icon will appear otherwise, you will see a text box containing the document. The Word document is embedded into Excel. If you decide to display the icon, clicking the Change Icon button allows you to select a different icon and provide a more meaningful caption.Unchecked: Displays the first page of the document.Ensure the Link to file option is unchecked.In the Object dialog box, select the Create from File tab.Select the cell where the object is to be inserted.The first method to embed a Word document into Excel uses the standard Excel Ribbon interface. One thing to be aware of is if you have a lot of embedded documents, it can significantly increase the size of the Excel file. Unfortunately, this also means making changes to the original Word document will not automatically update the copy in the Excel workbook. They don’t need access to the original file, as the embedded object is a copy of the original. If the Excel is sent to somebody else, they can view the embedded document. Other content you can embed in Microsoft ExcelĪn embedded Word document creates a new instance of the file inside the Excel workbook.
0 Comments
Leave a Reply. |