Microsoft Office Tutorials and References
In Depth Information
Using the Format as Table Gallery
Figure 3-6:
After you
select a
format from
the Table
gallery, the
Design tab
under the
Table Tools
The Design tab enables you to use Live Preview to see how your table would
appear. Simply click the Quick Styles button on the Ribbon and then position
the mouse or Touch Pointer over any of the format thumbnails in the Table
Styles group to see the data in your table appear in that table format. Click
the button with the triangle pointing downward to scroll up new rows of table
formats in the Table Styles group; click the button with the triangle pointing
upward to scroll down rows without opening the Table Styles gallery and
possibly obscuring the actual data table in the Worksheet area. Click the More
button (the one with the horizontal bar above the downward-pointing triangle)
to redisplay the Table gallery and then mouse over the thumbnails in the Light,
Medium, and Dark sections to have Live Preview apply them to the table.
In addition to enabling you to select a new format from the Table Styles
gallery, the Design tab contains a Table Style Options group containing a bunch
of check boxes that enable you to customize the look of the selected table
format even further:
Header Row to add special formatting and Filter buttons to each of the
column headings in the first row of the table.
Total Row to have Excel add a Total Row to the bottom of the table
that displays the sums of each column that contains values. To apply
another Statistical function to the values in a particular column, click
the cell in that column’s Total Row to display a drop-down list button
and then select the function — Average, Count, Count Numbers, Max,
Min, Sum, StdDev (Standard Deviation), or Var (Variance).
Search JabSto ::

Custom Search