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:
- Cursor Placement. Rosamine makes sure her cursor is placed in the area of her Word document where she wants to create the table.
- Insert Tab. She clicks on the Insert tab to display the insert button possibilities and selects the Table button.
- 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.
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.
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.
- 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.
- 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.
- Center. Next, Rosamine centers the Quarter numbers by selecting the three quarter cells and clicking on the centering button.
- 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.
- 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.
- 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.
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:
- Word Document Open. Rosamine has the Sales Report Word document open on her computer.
- Excel Application Open. Rosamine opens the Excel app.
- Excel Document Open. Next, Rosamine opens the Rowan Retail_Q2_Sales_Totals file.
- Sales Table. This is the sales table to be copied into the Word document. The next step is to copy and paste the table.
- Select Table. With the file open, Rosamine selects the entire table (all rows and columns).
- 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:
- One way is to simply click on the Word window and it will move forward in front of the Excel window.
- 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.
- 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.
This is how the document looks with the Excel table pasted into the 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.
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.
PRactice Questions