You also have a couple of other options here. In the window that pops up, click “Create from file,” then click “Browse” to navigate to and open the Excel spreadsheet on your computer’s storage drive. From the Insert table, click the “Object” button (the small blue-bordered square under the “Text” section): It’s also possible to embed an existing Excel file, which is handy if you’re trying to share data you’ve already accumulated. To start editing the spreadsheet again, double-click anywhere inside it to bring back the Excel controls. Here, you can adjust 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. When you’re done editing those values, you can click any other part of the Word document and the formatting defaults back to a basic table, suitable for printing or disseminating via read-only formats like PDF. 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. This is a screenshot of Word, but the menus and controls from Excel appear when editing the embedded spreadsheet.Įxcel spreadsheets have basically infinite amounts of rows and columns, but that’s not practical when you’re using that data as a table in a Word document. You can use any Excel formula you like in this embedded version of the program. So, for the “Yearly Total” value for “Space Sprockets” in cell F2, I use the formula “sum(B2:E2)” to add all four values across the row and get my total automatically. I’ve filled the standard cells with made-up values for Stanley’s Sprocket sales, and used one of the most common sum formulas for the cells in the last column. Click the “Excel Spreadsheet” button in the drop-down menu. A bit "cleaner" in a way.To insert an Excel table in Word 2016, click the “Insert” tab at the top of the window, and then click the “Table” button. So a direct lookup rather than a lookup in already looked up material. However, if being used elsewhere, one could also simply use the formulas used to poipulate this table directly, not looking up something in the table, but rather doing the first level lookup in the source data. If one used a given number of spaces between first/second and a different number between second/third columns, that could be a reliable basis for pulling the data from the table for use elsewhere. If the test succeeds, then the cell simply has the text result it now has with no reading of the second and third columns, as they have nothing, as I understand it. One would need toTEXT()` wrap each and add spaces as required for appearance, but the look could be achieved, though with a fair bit of work. If NOT, then one has the current formula for that column AND the formulas for the second and third columns. Since there are explicity numerical entries and alpha entries in the first column, but NO alphanumeric entries, one could first test for that with ISTEXT(). One could remove them, which might make it more palatable to users.
But it'd work to show the data AND the full entry in the first column. It would not let the table's data be used directly in further calculations, and the second and third columns would not really be used which might disturb a user.
If you reallllly wanted to do it, sort of,you could make a complicated formula for the leftmost cell that should handle it. I use Excel 2013, but I believe this question applies to 2007+ versions of Excel.