Add calculating rows and columns to a Word table. If youre not an Excel fan, but you need a few basic calculations, you can use Word. Its calculating feature is rudimentary and it certainly cant replace Excel. On the other hand, this feature is helpful when your primary need is word processing and not number crunching. The rules are simple Enter the values youll be calculating into a table. If youre calculating rows, add a new column to the right or left of the table and click Formula in the Data group on the contextual Layout tab. If youre calculating columns, add a new row to the bottom or top of the table and click Formula. As you can see, calculating values in a Word table is straightforward and Word does most of the work for you. Lets work through a quick example using the table shown below. Specifically, well total commissions by salesperson and by specific vehicle types. To do so, well add a calculating column to the right and a calculating row at the bottom. First, lets add the calculating column, as follows Insert a new column to the right by clicking any cell in the right most column and clicking Insert Right in the Rows Columns group on the contextual Layout tab. In Word 2. 00. 3, select Insert from the Table menu, and then select Columns To The Right. Select the second cell in the new column not the header cell, the one at the end of the Smith row. Click Formula in the Data group. In Word 2. 00. 3, choose Formula from the Table menu. Word anticipates your needs and supplies the appropriate formula for you add everything to the left of this cell. If Word doesnt supply the formula for you, enter SUMLEFTFrom the Format dropdown, choose the currency format, ,0. Click OK. You might have to resize the column to accommodate the new content. Repeat the process for each row, but be careful. Once you add the first formula, Word will detect values above the current cell and default to ABOVE instead of LEFT, in the formula. Youll need to change SUMABOVE to SUMLEFT. Adding totals to each column is just as easy Add a new row to the bottom of the table. Click in the third cell the Car, New column. Click Formula in the Data group. You wont have to change the formula, because Word will detect the values above and default accordingly. Set the format. Click OK. Repeat the process for each column. Word calculations dont update automatically. To update a calculating cell, select it and press F9. You can select the entire table and press F9 to update all of the calculations in the table. Similarly, you can select a row, a column, or a block of rows and columns. Avoid merging and splitting cells in a calculating table. Doing so can have unexpected results that are difficult to troubleshoot. If you are looking for a Microsoft Word tutorial, this is the site. Our Microsoft Word tutorial provides the help you need to get started using Microsoft Word. How do I copy Word tables into Excel without splitting cells into multiple rows There is an easier way. If you have a Google Gmail account, you can open up Google Drive, and create a new spreadsheet, then copy the entire table from Microsoft Word into the Google Spreadsheet. Once you have it in the desired format, you can then copy the table into Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |