Page 146 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

To modify table style options:

You can turn various options on or off to change the appearance of any table. There are several
options: Header Row, Total Row, Banded Rows, First Column, Last Column, Banded Columns,
and Filter Button.Select any cell in your table, then click the Design tab.

1. Check or uncheck the desired options in the Table Style Options group. In our example,
we'll check Total Row to automatically include a total for our table.

2. The table style will be modified. In our example, a new row has been added to the table
with a formula that automatically calculates the total value of the cells in column D.

TIP
You can turn various
options on or off to change
the appearance of any
table.

Depending on the type of content you have—and the table style you've chosen—these options can
affect your table's appearance in various ways. You may need to experiment with a few different
options to find the exact style you want.

137 | P a g e