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
- 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
May be interested
- How to align beautiful Word documentshow to align beautiful word documents. in order to prepare documents in word, most of you have learned in basic computer programs. but to align word documents beautifully, properly, then many new acquaintances will have many difficulties.
- Set background color in PowerPointintroduce how to apply a background color in powerpoint. step 1: go to the design - variants -background styles tab - select one of the built-in colors: step 2: if you want to choose other color schemes - click format background.
- Use the Font format text dialog box in PowerPointintroduce how to use the font format text dialog box in powerpoint. to use the font dialog box, you can choose the following formats: 1. change the font, font size: - to change the font - highlight text content to be formatted - click the fo icon
- ENCODEURL function - The function returns a query string with URL code in Excelencodeurl function: the function returns a query string with the url code. support functions from excel 2013 onwards. syntax: encodeurl (text)
- FILTERXML - Function that returns specified data from XML content using the specified XPath in Excelfilterxml function: the function returns specified data from xml content using the specified xpath. support functions from excel 2013 onwards. syntax: filterxml (xml, xpath)
- WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excelwebservice function: the function returns data from a web service on the internet or intranet. support functions from excel 2013 onwards. syntax: webservice (url)