One of the benefits of using the Microsoft Office suite of products is the integration among the apps. For example, if you have data within a spreadsheet in Excel that you need to include in a report on Word, you can transfer that information with the click of a few buttons. Instead of copying the data from Excel and pasting it into Word, which may not reflect further changes made to the original spreadsheet, you can insert an Excel spreadsheet into Word.
You can insert an Excel spreadsheet into Microsoft Word in various ways, and we have covered the top methods below.
How to Insert an Excel Spreadsheet Into Word Using the Insert Table Option
The Insert tab on the Word Ribbon has different options, including an Insert Table button, which can be used to insert an Excel Spreadsheet into Word. This option would launch a blank Excel spreadsheet in which you can make edits. Any edits you make to the spreadsheet will be shown in table form in your Word document. Here’s how to do so:
Step 1: Click the Start button on the taskbar to open the Start menu and type word to search for the app.
Step 2: From the results, click on the Microsoft Word app or document to open it.
Step 3: On the Word canvas, place your cursor in the location you would like to insert the spreadsheet.
Step 4: On the Word Ribbon, click the Insert tab.
Step 5: Within the Tables group, click the Table option.
Step 6: Click Excel spreadsheet to insert a table in Word and launch a blank Excel workbook.
Step 7: In the blank workbook, enter the data you would like to see in your Word document.
Step 8: Click Save on the Excel workbook to see your changes in the Word table.
How to Insert an Excel Spreadsheet Into Word Using the Insert Object Option
If you do not want to insert the data in the Excel spreadsheet into your Word document, an alternative is to embed the spreadsheet as an object into your document. Embedding the Excel spreadsheet into your Word document is like including a shortcut for individuals to access the spreadsheet. Here’s how to do so:
Step 1: Click the Start button on the taskbar to open the Start menu and type word to search for the app.
Step 2: Click on the Microsoft Word app or document from the results to open it.
Step 3: On the Word canvas, place your cursor in the location you would like to embed the spreadsheet.
Step 4: On the Word Ribbon, click the Insert tab.
Step 5: Within the Text group, click the Object dropdown.
Step 6: Click Object. This will launch the Object dialog box.
Step 7: Click the Create New tab if you would like to create a new spreadsheet. Click the Create from File tab if you already have an existing spreadsheet.
Step 8: If you select the Create New tab, scroll through the Object type list and select Microsoft Excel Worksheet. If you select the Create from File tab, click Browse and scroll through your File Library to select the Excel worksheet you would like to embed.
Step 9: Tick the box beside Display as icon. This will ensure the Excel data isn’t presented as a table and only an icon of the spreadsheet is shown in your Word document.
Step 10: Click OK.
How to Insert an Excel Spreadsheet Into Word Using the Insert & Link Option
You can transfer the data within an Excel spreadsheet into Word using copy and paste. If you are worried about manually updating the data in Word every time you make changes to the Excel spreadsheet, you can work around this, too. Rather than using the simple paste option when transferring the data, you can use the Link & Use Destination Styles or Link & Keep Source Formatting option. Here’s how to do so:
Step 1: Open the Word document you would like to insert the spreadsheet into.
Step 2: Open the Excel worksheet with the data you want to copy to Word.
Step 3: Select and copy the cells in the Excel worksheet you would like to insert into Word.
Step 4: On the Word canvas, place the cursor where you would like to insert the data.
Step 5: Right-click the Word canvas and select either Link & Use Destination Styles or Link & Keep Source Formatting options.
Step 6: When you make changes to the Excel spreadsheet data, right-click on the transferred table in Word and select Update Link. This will ensure the data in the table is kept up to date.
Fixing Excel Not Responding
If, after inserting the Excel file into your Word document, you notice that the Excel does not respond or takes time to respond, there are different ways you can fix it. You can force close the Excel using Task Manager or disable COM add-ins to stop the freezing. Having said that, we hope you can now integrate your Excel files in Microsoft Word seamlessly.
Categories: How to
Source: thpttranhungdao.edu.vn/en/