Skip to main content
Business LibreTexts

18.4: Excel Table in Word Document

  • Page ID
    46676
  • Learning Outcomes

    • Create a Word document with integrated Excel table.

    There are a couple of ways to integrate an Excel table into a Word document.

    Option 1 for Table Integration

    Rosamine starts to type in her report. Along the way she decides to change the theme colors again to more of a brown color and repeats the theme change process like she did previously. She continues writing her text and now needs to add an Excel table to her report highlighting the three different store Q2 sales numbers.

    She has the second quarter sales information from another report, but doesn’t have the Excel file itself to copy into her Word document. Because she has no existing Excel file, she creates her own table through the following steps:

    A Microsoft Word document is open with a sales report displayed. The navigation menu has been opened up to the left of the content. There are three green arrows, the first is pointing at the cursor location. The second is pointing at the option to insert a table from the insert tab in the ribbon menu. The third green arrow is pointing at the option to insert an excel spreadsheet.
    1. Cursor Placement. Rosamine makes sure her cursor is placed in the area of her Word document where she wants to create the table.
    2. Insert Tab. She clicks on the Insert tab to display the insert button possibilities and selects the Table button.
    3. Excel Spreadsheet Option. This button creates a little Excel spreadsheet table within Rosamine’s Word document.

    The Excel table is now in her Word document and ready for data to be entered. Notice how the color of the upper toolbar is displaying the Excel green and that the Home tab is selected. This is an indicator to Rosamine to know she is now working with an Excel table. She can now begin to type in the data for the table.A Microsoft Word document is open with a sales report displayed. A blank excel spreadsheet has been inserted into the word document.

    Note: If at any time Rosamine clicks outside the table it will revert back to the Word document and she can double-click back on the table to open it up for data entry again.

    A Microsoft Word document is open with a sales report displayed. A blank excel spreadsheet has been inserted into the word document. There are 6 green arrows pointing at various things in the document. The first shows where the cell style option is, the second shows how to select the auto sum button. The third green arrow is pointing at the center option and the fourth at how to color in the cells. Finally the fifth arrow is pointing at where to insert borders and the sixth at the option to make the content bold.
    Cell Style. AutoSum. Center. Color in Cells. Borders. Bold.

    Rosamine has entered the sales figures from the three different stores, and wants to make additional changes to the table. This is how she changes the table.

    1. Cell Style. Rosamine selects and formats the column of numbers to be currency cells and to display the dollars generated from sales for the second quarter of the year.
    2. AutoSum. With the bottom cell selected, Rosamine clicks the AutoSum button, which totals the three sales figures for all stores for the GM to easily see what total sales were generated from the second quarter.
    3. Center. Next, Rosamine centers the Quarter numbers by selecting the three quarter cells and clicking on the centering button.
    4. Color in Cells. The table needs a contrasting color to make the titles and totals stand out. Rosamine selects the top and bottom rows, clicks on the paint bucket button, and chooses a green color for the table.
    5. Borders. To make the table look more defined in the document, Rosamine selects the entire table, then the Border button, then selects the “thick box border” to be placed around the outside of the table.
    6. Bold. The last table change Rosamine uses is to select the titles and totals rows and bold each of them to contrast with the other data.

    Now the table is complete, but it still shows too many unused cells. Rosamine resizes the table by holding down the left mouse button and dragging the sides of the table to the correct size for the report.A Microsoft Word document is open with a sales report displayed. An excel spreadsheet has been inserted into the word document. There are two green arrows pointing at the right side and bottom of the excel spreadsheet. The two arrows are indicating how to resize the spreadsheet.

    Her work complete, she clicks off to the right. Her Word document is ready for more text and additional data.

    Option 2 for Table Integration

    What if Rosamine has access to the store sales information Excel file directly? With this scenario, she can place it directly into her Word document with no need to make her own table. Here is how Rosamine can insert an existing Excel file:

    A Microsoft Word document is open with a sales report displayed. The navigation menu has been opened up to the left of the content. In a separate window an excel sheet has opened up. There are four green numbers showing the important parts of the display. The first is showing that the word document is open and active, the second shows that excel application is running. The third shows that the excel document is open and the fourth points to a sales table that has been entered into the excel spreadsheet.
    1. Word Document Open. Rosamine has the Sales Report Word document open on her computer.
    2. Excel Application Open. Rosamine opens the Excel app.
    3. Excel Document Open. Next, Rosamine opens the Rowan Retail_Q2_Sales_Totals file.
    4. Sales Table. This is the sales table to be copied into the Word document. The next step is to copy and paste the table.
    A Microsoft Word document is open with a sales report displayed. The navigation menu has been opened up to the left of the content. An excel sheet with data entered is open in front of the word document. There are two green numbers showing how to select a table and how to copy a table.
    1. Select Table. With the file open, Rosamine selects the entire table (all rows and columns).
    2. Copy Table. Rosamine right-clicks with her mouse and selects the Copy function. She can also accomplish this by using the Ctrl+C keys to copy the table.

    Next is getting back to the Word document. There are three ways to accomplish this:

    1. One way is to simply click on the Word window and it will move forward in front of the Excel window.
    2. A second way is to toggle back and forth with the keyboard by holding down the Alt key and tapping on the Tab key (Alt+Tab). This opens a small window displaying all the apps currently running on the computer. She can continue to hold down the Alt key and click the Tab key to scroll through the options.
    A Microsoft Word document is open with a sales report displayed. The navigation menu has been opened up to the left of the content. An excel sheet with data entered is open in front of the word document. A feature to toggle between the two windows has opened up in front of the microsoft excel sheet and word document.
    1. The third option is to place the two documents side-by-side on the computer screen. This typically requires resizing of the document windows.

    Now that the Word document is selected, Rosamine now places the cursor where the table should be and right-clicks with her mouse. The menu appears again. She selects the Paste Option small clipboard icon, and the table is copied into the Word document.

    A Microsoft Word document is open with a sales report displayed. The navigation menu has been opened up to the left of the content. An excel sheet with data entered is behind in front of the word document. There are two green arrows pointing at the word document at where the cursor has been placed and how to past a table into the document.

    This is how the document looks with the Excel table pasted into the document.A Microsoft Word document is open with a sales report displayed. The navigation menu has been opened up to the left of the content. An excel sheet with data entered is open behind of the word document. An excel sheet has been pasted into the word document.

    Here is an illustration of copy and pasting using the keyboard shortcut keys (Ctrl+C, Ctrl+V) where Rosamine would first select the Excel table, copy the table, then paste it into the Word document.A Microsoft Word document is open with a sales report displayed. The navigation menu has been opened up to the left of the content. An excel sheet with data entered is open to the right of the word document.

    Once the copied Excel table is in the Word document, it can be modified by double-clicking in the desired cell and then it can be changed however desired. It does not open a small Excel spreadsheet as the table created within Word in Option 1 did.

    The table is now set and Rosamine is ready for more text and an additional data chart.

    CC licensed content, Original
    • Excel Table in Word Document. Authored by: Sherri Pendleton. Provided by: Lumen Learning. License: CC BY: Attribution