![]() ![]() Select an appropriate Number format and click “OK. The “ABOVE” parameter tells Word to add all the values above the current cell. This time, we’ll use the following formula: =SUM(ABOVE) Head to the “Layout” tab and click the “Formula” button again. Place your insertion point in an empty cell at the bottom of the “Total” column (insert an extra row if you need to). To apply shading to a table, select the parts of the table you want to shade. NOTE: We used Word 2013 to illustrate this feature. ![]() ![]() For example, you can add shading to every other row and/or column using a color or pattern. ![]() Say, for example, that we wanted to add all the values in the “Total” column to figure out our total overall sales. Adding shading to the table can make reading the data in our table easier. This technique works pretty much the same way for columns as it does for rows. When you’re done, you’ll have a fully formed table. Unfortunately, Word doesn’t let you select a bunch of cells at once and create a formula for all of them in one step, so you’ll have to perform these same steps in each of the other cells in the “Total” column. The result of the formula displays in the cell. Select an option from the Number format drop-down list to specify the format for the result of the formula.Ĭlick “OK” to accept the settings and insert the formula into the cell. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |