1

In my Excel 2010 file and in one of its sheets I have a small table. As following, when I checked the Total Row option in Table tools > Design > Table style options > Total Row the tabled appeared as follows. But it is against of the info when I hold the mouse pointer over the Total Row check box because that info says: The total row is a row at the end of the table which displays totals for each column. But in practice it only displays the total for the last column not each column! Any idea why?

enter image description here

1 Answer 1

0

By default, Excel only shows a sum in the right-most cell of the totals row, but you can add totals to any numeric column.

Click into the cell in the totals row to see a drop-down arrow. Click that and select what calculation you want in that column.

enter image description here

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .