Microsoft Office Tutorials and References
In Depth Information
Selecting Table Style Options
The table style treated the range as a single unit and modifi ed its overall appearance. In
this case, Table Style Medium 2 formatted the range so the header row appears in a white
font on a blue fi ll and the remaining rows are formatted as banded rows. In addition, fi lter
arrows appear next to the column titles in the header row. These fi lter arrows are applied
when the user wants to hide or fi lter out different table rows that contain certain data.
Tom doesn’t want to fi lter the data right now, so you will remove the arrows and work
only with elements related to the table style.
To remove the filter arrows from the table:
1. Click cell to make the table active. B6
2. Click the Data tab on the Ribbon.
3. In the Sort & Filter group, click the Filter button. The filter arrows disappear from
the header row.
Selecting Table Style Options
After you apply a table style, you can choose which table elements to include in the
style. Table styles have the following six elements that can be turned on or off:
Header Row , which formats the fi rst row of the table
Total Row , which inserts a new row at the bottom of the table that adds the column
values
First Column , which formats the fi rst column of the table
Last Column , which formats the last column of the table
Banded Rows , which formats alternating rows in different colors
Banded Columns , which formats alternating columns in different colors
For example, if you turn on the Header Row option, you can specify a format for the
table’s fi rst row, which usually contains text that describes the contents of each table
column. If you insert a new row at the top of the table, the new row becomes the header
row and is formatted with the table style.
In the table style you just used, only the Header Row and Banded Rows options are
on. Although the other elements are still part of the table structure, the current style does
not format them. Tom wants you to format the table’s last column and header row as well
as remove the banded rows effect.
To modify the table style:
1. If necessary, click cell to make the table active. The Table Tools contextual tab B6
appears on the Ribbon.
You can click any cell
within a table to make the
table active; you do not
need to select all of the
table cells.
2. Click the Design tab on the Ribbon. The table design options appear on the
Ribbon.
3. In the Table Style Options group, click the Last Column check box to insert a
check mark. The last column is formatted.
4. In the Table Style Options group, click the Banded Rows check box to remove
the check mark. The banded rows are removed from the table.
Only the Header Row and Last Column elements appear in the table. You’ll use a
built-in table style to format them.
5. In the Table Styles group, click the More button
. The Table Styles gallery opens.
Search JabSto ::




Custom Search