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:
How to insert an Excel table into Word Picture 1
Step 2: The object dialog box appears, select the Creat From File tab -> click Browse to select the Excel table to insert:
How to insert an Excel table into Word Picture 2
Step 3: Select the path to the Excel file to be inserted -> click Insert:
How to insert an Excel table into Word Picture 3
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:
How to insert an Excel table into Word Picture 4
After clicking OK, the Excel spreadsheet is inserted into Word:
How to insert an Excel table into Word Picture 5
You can edit a spreadsheet directly in Word by double clicking on the worksheet:
How to insert an Excel table into Word Picture 6
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!
How to insert an Excel table into Word Picture 7
How to insert an Excel table into Word Picture 8
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
May be interested
How to align beautiful Word documents
Set background color in PowerPoint
Use the Font format text dialog box in PowerPoint
ENCODEURL function - The function returns a query string with URL code in Excel
FILTERXML - Function that returns specified data from XML content using the specified XPath in Excel
WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel