# Lesson 11

Preview

Customizing a Table – Using the Total Row feature; Practice Exercise 10

Practice Exercise 10: Customize a table by applying the Total Row feature

STEP 1: ​Continue using data file:FIRST_RANGE_TO_TABLE_EXERCISE; Select the CREATE TABLE TAB (FIGURE 1).
Notice that on the table is a small  arrowhead on the bottom-right cell. It is used for adding rows/columns.

STEP 2: ​Locate the small dark mark in the bottom-right corner of cell C13 (FIGURE 2).If you move mouse near this mark, your mouse symbol will turn into a slanted double-headed arrow. (The double-headed arrow you see on your PC will be much smaller. You might want to consider increasing the zoom to see it better).

​STEP 3: Click and drag your mouse downward to add a row (FIGURE 3).

​STEP 4: You will see a dark border surround the table, including the new row (FIGURE 4).
​To add a column, do the same thing except move your mouse to the right instead of downward.

STEP 5: ​We will now see how to add a “Total Row” for the table. Ensure you have a cell in the table active.

In the Table Style Options section of the Ribbon, select Table Tools Design Tab,
Check the box for Total Row ​(FIGURE 5).

STEP 6: ​You now have a Total row added, with the Actual column total showing. Notice that the small arrow for adding rows/columns has moved to the total row (FIGURE 6).

STEP 7: Click on cell C14, “668,600.00”. Click on the black, downward pointing arrowhead to see a drop-down menu. You have various options to choose from; SUM is the default.
Select Average (FIGURE 7). Cell C14 now shows the average of the “Actual” column.

​Select Undo to change back to SUM.

STEP 8: ​You can add rows between the last row of data and the Total row (FIGURE 8).

​STEP 9: Click on cell C13. Press Tab key. You have now inserted a new row (FIGURE 9).

END OF LESSON

Back to: Intermediate Excel 2016 > Module 2 – Intermediate Excel 2016