Microsoft Office Tutorials and References
In Depth Information
Although Format As Table does a pretty good job with simple tables, you usually need to
make a few adjustments afterward. For example, starting with the raw data shown in
Figure 9-1, we applied the Table Style Medium 20 format. Figure 9-6 shows the result.
Figure 9-6 In seconds, you can transform a raw worksheet into something more presentable.
As you can see in Figure 9-6, the title and subtitle in cells A1 and A2 were not part of the
table, and therefore were not formatted, so we applied additional formatting manually to
arrive at the result shown in Figure 9-2. In addition, we applied number formatting to the
cells containing data. Nonetheless, using Format As Table speeds up the formatting process
and provides at least one formatting feature that is otherwise unavailable: automatic row
and column banding, which was one attribute of the automatic format we applied in Figure
9-6. Another cool part of using Format As Table is the automatic preview feature. After you
define a table using the Format As Table command, you can then use the Format As Table
gallery to preview other predeined formats. (It doesn’t work on raw data.) Rest the pointer
on any format in the gallery, and the associated formatting is temporarily reflected in the
table you have already created, but it is not actually applied unless you click.
After you create a table, a context-triggered tab appears on the ribbon only when you
select a cell or cells within the table. Figure 9-7 shows the Table Tools Design tab.
The Design tab contains formatting commands in the Table Style Options and Table Styles
groups. The latter group contains the same gallery as the Format As Table command on
the Home tab. In Figure 9-7, we selected both the First Column and Last Column check
boxes in the Table Style Options group, which in this particular predeined format applied
bold formatting to the fonts in those columns. Also, the Filter Button check box was cleared
to unclutter the appearance of the worksheet. (You can always redisplay the filter buttons
when you need to massage the numbers; this chapter is all about appearances.) You can