Excel: The Table is Set  Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

Calculate the Totals

Adding a Total Row to the Table is as simple as checking the option.

 

Try It: Add a Total Row
Go to Table Styles.

Select: Total Row.

 

What Do You See? By default, the Total Row will be added to the bottom of the Table. Microsoft Excel will insert a formula for your Total: $33,540.00.

 
Table Tools->Design ->Table Style Options -> Total Row

 
 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 2. Formatting Data and Content

  2.4. Format data as a table  2.4.2.  Add total rows to a tables