How to insert an Excel table into Word
In the process of working with spreadsheets, there are some cases where the data in an Excel spreadsheet exceeds the size of an A4 page, so when printing on Excel the data is lost. The fastest way for you to copy the data sheet to Word helps you to display excess data on the spreadsheet to the next page. The following article shows you how to insert Excel tables into Word.
There is a small note when you perform inserting Excel table into Word you should keep these 2 files in the same root directory, during work you should not move to another location, if so when you update on the table calculation will occur when the Word file has inserted the spreadsheet. To insert an Excel table into Word, follow these steps:
Step 1: In the Word file you want to insert the Excel table, click the Insert tab -> Text -> Object:
Step 2: The object dialog box appears, select the Creat From File tab -> click Browse to select the Excel table to insert:
Step 3: Select the path to the Excel file to be inserted -> click Insert:
Step 4: After selecting the Excel worksheet, select the Link to file check box, so that when you edit the content on the Excel workbook, the Excel workbook in Word is updated -> click OK:
After clicking OK, the Excel spreadsheet is inserted into Word:
You can edit a spreadsheet directly in Word by double clicking on the worksheet:
So when you edit on Word or on Excel spreadsheets, the content updates both places that contain the workbook.
The above is a detailed guide on how to insert Excel tables into Word.
Good luck!
You should read it
- Instructions for inserting table captions in Word
- How to insert a Word document into an Excel file
- How to create a table, insert a table in Excel 2016
- How to insert a table, create a table in Word 2016
- MS Word - Lesson 8: Creating a table
- MS PowerPoint 2007 - Lesson 8: Insert tables in PowerPoint
- Manipulating tables in Word
- How to create a table and insert a table in Excel?
- Insert line shortcut in Excel - Shortcut insert Excel
- How to center the cell in the table on Word
- Microsoft introduced a new tool to turn an image table into an editable Excel table
- Instructions for inserting delta symbols in Excel
Maybe you are interested
Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excel
How to turn off auto formatting in Excel
Here's What to Do Before Sharing an Excel Spreadsheet
How to use the TREND function in Excel
How to create Progress Bar in Excel, conditional progress bar
How to change auto save time on Excel, Auto Save Excel File