Like peanut butter and chocolate, a word processor with some bones spreadsheet chops makes a fantastic combination. When you want some rather easy number-crunching embedded in an otherwise ordinary text document, Microsoft Word has yous covered, thanks to baked-in functionality from its sis programme Excel.

Word's implementation of Excel spreadsheets substantially embeds a tiny copy of the program, right in the middle of your weekly newsletter to the Booster's Guild. While editing the Excel section of the document, y'all accept admission to all of the Excel controls as if you were using Excel in its own window. You can add together standard text and numeral value cells, and crucially, formulas that apply specifically to the Excel mini-window.

To insert an Excel table in Word 2016, click the "Insert" tab at the peak of the window, and so click the "Table" button. Click the "Excel Spreadsheet" button in the drop-down menu.

Hither's a bones instance. I've filled the standard cells with made-upwards values for Stanley's Sprocket sales, and used one of the nearly common sum formulas for the cells in the final column. Then, for the "Yearly Full" value for "Infinite Sprockets" in cell F2, I use the formula "sum(B2:E2)" to add together all four values beyond the row and go my total automatically. You can use any Excel formula you similar in this embedded version of the plan.

This is a screenshot of Word, but the menus and controls from Excel announced when editing the embedded spreadsheet.

Excel spreadsheets accept basically space amounts of rows and columns, but that'southward not practical when you're using that data as a tabular array in a Word certificate. To change the number of visible rows and columns, click and drag the anchor points, the black squares that appear in each corner and midpoint of the box around the Excel spreadsheet.

When you lot're done editing those values, you can click any other part of the Word certificate and the formatting defaults back to a basic tabular array, suitable for printing or disseminating via read-only formats like PDF. Here, you lot can adapt the width and height of the table to better fit the formatting of the Word document without changing the number of visible columns or rows.

To start editing the spreadsheet once again, double-click anywhere inside it to bring back the Excel controls.

It's likewise possible to embed an existing Excel file, which is handy if you're trying to share data you've already accumulated. From the Insert table, click the "Object" button (the pocket-sized blue-bordered foursquare nether the "Text" section):

In the window that pops upward, click "Create from file," then click "Scan" to navigate to and open up the Excel spreadsheet on your calculator'south storage drive. Y'all likewise take a couple of other options here. Selecting the "Link To File" option keeps the spreadsheet you see in Word linked to the actual Excel spreadsheet, and then long equally they are kept in the same locations as when you linked them. Changes y'all make in either place are reflected in the other. Y'all can also cull the "Display As Icon" option to show the spreadsheet as a unproblematic icon in the Word document that y'all can click to open the spreadsheet in Excel.

When y'all're done, simply click "OK" to insert the spreadsheet.

Depending on your Word formatting, y'all may need to resize or edit information technology to make everything visible.

The above article may contain affiliate links, which aid back up How-To Geek.