Page 160 - Excel 2013 All-in-One For Dummies

142 Formatting Tables from the Ribbon
of the cells with the column labels). To hide these AutoFilter buttons, click the Filter button on the Data tab or press Alt+AT. (You can always redisplay them by clicking the Filter button on the Data tab or by pressing Alt+AT a second time.)
The Design contextual tab enables you to use the Live Preview feature to see how your table data would appear in other table styles. Simply select the Quick Styles button and then highlight any of the format thumbnails in the Table Style group with the mouse or Touch pointer to see the data in your table appear in that table format, using the vertical scroll bar to scroll the styles in the Dark section into view in the gallery.
In addition to enabling you to select a new format from the Table gallery in the Table Styles group, the Design tab contains a Table Style Options group you can use to further customize the look of the selected format. The Table Style Options group contains the following check boxes:
✦ Header Row: Add Filter buttons to each of the column headings in the first row of the table.
✦ Total Row: Add a Total row to the bottom of the table that displays the sum of the last column of the table (assuming that it contains values). To apply a Statistical function other than Sum to the values in a particu- lar column of the new Total row, click the cell in that column’s Total row. Doing this displays a drop-down list — None, Average, Count, Count Numbers, Max, Min, Sum, StdDev (Standard Deviation), or Var (Variation) — on which you click the new function to use.
✦ Banded Rows: Apply shading to every other row in the table.
✦ First Column: Display the row headings in the first row of the table in
bold.
✦ Last Column: Display the row headings in the last row of the table in bold.
✦ Banded Columns: Apply shading to every other column in the table.
Keep in mind that whenever you assign a format in the Table Styles gallery to one of the data tables in your workbook, Excel automatically assigns that table a generic range name (Table1, Table2, and so on). You can use the Table Name text box in the Properties group on the Design tab to rename the data table by giving it a more descriptive range name.
When you finish selecting and/or customizing the formatting of your data table, click a cell outside of the table to remove the Design contextual tab from the Ribbon. If you later decide that you want to further experiment with the table’s formatting, click any of the table’s cells to redisplay the Design contextual tab at the end of the Ribbon.