![]() ![]() 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. To insert an Excel table in Word 2016, click the “Insert” tab at the top of the window, and then click the “Table” button. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |