Microsoft Office Tutorials and References
In Depth Information
Changing the Look of a Table
Use the Create Table dialog box to verify that Excel selected the table dimensions correctly.
Excel may not specify the table’s dimensions correctly if the table isn’t separated from other information by at least
one empty row or column. If Excel doesn’t choose the range correctly, just specify the exact range for the table in the
Create Table dialog box. Better yet, click Cancel and rearrange your worksheet such that the table is separated from
your other data by at least one blank row or column.
To create a table from an empty range, just select the range and choose
Insert Tables Table. Excel creates the table, adds generic column headers (such as
Column1 and Column2), and applies table formatting to the range. Almost always, you’fill
want to replace the generic column headers with more meaningful text.
Changing the Look of a Table
When you create a table, Excel applies the default table style. The actual appearance depends
on which document theme is used in the workbook (Page Layout Themes Themes). If you
prefer a different look, you can easily change the entire look of the table.
Select any cell in the table and choose Table Tools Design Table Styles. (At a lower
screen resolution, you will need to click the Quick Styles button in the Table Styles group
of the Design tab.) The Ribbon shows one row of styles, but if you click the More button
at the bottom of the scroll bar to the right, the Table Styles group expands, as shown in
Figure 19.4. The styles are grouped into three categories: Light, Medium, and Dark. Notice
that you get a Live Preview on the table as you move your mouse among the styles. When
you see one you like, just click to apply it. For a different set of table style choices, choose
Page Layout
Themes to select a different document theme.
Search JabSto ::

Custom Search