web analytics

IMPORTING EXCEL TABLES IN MICROSOFT WORD 2013

Microsoft Word 2013

This article “shows” you how to import Excel tables in Word (2013) on the most efficient way. It explains the detailed processes (from opening a new blank document to choosing paste options) you have to do in order to learn the procedure for importing Excel tables. It describes several importing methods and some of them are more complicated while others are simple.

There are few ways of importing Excel tables into Word, depending on the effect you wish to achieve. For simple data transferring from Excel table to Word, you need to know the first way:

01 - Blank Document

Open a new Blank Document from the New section in Word File Tab. You may also open an existing Word Document from the Open Section and selecting the Computer option.

02 - Copying Excel Table

Select or highlight the required cells from the table and right click on the selected area. Then, choose the Copy tab from the menu.

03 - Paste Options

In the Word document, point the cursor at the spot where you like to Paste the table. Right Click on the mouse and from the Paste Options Tab, select the first or the second icon. First one (Keep the source formatting) will paste the table with the style from Excel workbook.

04 - Keep Source Formatting Icon

The second one (Keep destination styles) will paste the table with the predefined Word style.

05 - Use Destination Styles Icon

Also, you may simply press Ctrl + V to paste the table where the cursor is. From the other Paste Options you can choose to paste the table as picture or as text.

The second way is used when you wish to calculate the data in the pasted table (update the sales’ figures, etc.). For this, you should insert the table as an Excel object.

06 - Selecting Object from Insert Tab

First, from the Insert tab, select the Object Drop-down Arrow and choose Object.

07 - Create from File Tab

In the Object dialogue box select the Create from File tab. Then press the Browse… button and find the Excel file where the preferred table is. Select the file and press Insert. Then, press OK.

08 - Imported Excel Table

Since the Excel spreadsheet is inserted as an object, you can actually change the sales figures and SUM will be automatically recalculated.

09 - Create New Tab

You may choose the alternative way to do the same by selecting the Create New tab in Object dialogue box and choosing Microsoft Excel Worksheet from the Object type list. To finish press OK.

10 - Imported Excel Cells

You will get an Excel kind of worksheet where you can paste the table (selected cells) from the Excel document.

11 - Pasting Table in Cells

Just right click on the Excel kind of table in Word and click on the Paste option.

12 - Pasted Table in Cells

Now you can change the figures in the table. Click out of the table in Word to escape from the “Excel” mode.

You can try another way:

13 - Selecting Import Table

Select Table icon from Insert tab in Word document and choose the Insert Table tab.

14 - Insert Table Dialogue Box

In the Insert Table dialogue box put the exact number of columns and rows as those in the Excel table from which you wish to copy. Select the AutoFit to contents button and click OK (this is not necessary, you may choose Auto fit to window).

Then, go to your Excel workbook and select the cells from the table. With right click on some of the selected cells, select Copy.

15 - Selecting Cells from Table

Select the cells from the created table and right click over them (the grey area).

16 - Overwrite Cells Icon

Choose the Overwrite Cells icon from the Paste Options. This way, you can change the figures but the formulas (SUM) will not be active.

Other thing you can do when pasting table from Excel is:

17 - Create from File Tab Checkboxes

After selecting Insert Tab, choosing Object, Object…, choose the Create from File section. Then, click the Browse button, find and insert the file where the Excel table is. If you select only the Link to file check box and press OK, the Excel kind of table will appear in the Word document. Now, if you change the content in Excel, it will be reflected in the Word table.

18 - Word Message  Box

Even if you made the changes in Excel table after closing the related Word file, you will be asked by Microsoft Word about updating the file when you open the Word file. Click Yes to confirm the update and the changes in Excel will reflect in the related Word file.

19 - Excel Icon

If you select only the Display as Icon check box, then Excel icon will appear in your Word document. When you double click on the icon, the Excel workbook window will appear. This is the content of the selected file from the File Name list in Create from File tab in Object dialogue box.

There is a third way, where first you should select the cells from Excel Workbook, then right click on the Word workbook and chose the third (Link & Keep Source Formatting) or the fourth icon (Link & Use Destination Styles) under the Paste options. Then right click on the pasted table and select Link Worksheet Object, Editor Link or Open Link. After changing the data in the original Excel file (table) you must right click on the pasted table again and click Update Link.

Leave a Reply