Microsoft Office Tutorials and References
In Depth Information
Table styles format the rows and columns of your
table to make your table easier to read. When you
create a table, Excel applies the default style. You
can easily change or remove any style applied to
your table. Excel provides you with a large gallery of
styles from which to choose. As you roll your cursor
over each style in the gallery, Excel gives you a quick
preview of how each style will appear when applied.
Excel also provides a number of table-style options
you can use to modify your table. By choosing
banded rows or banded columns, you can have every
other row or every other column appear in a different
color. You can also apply special formatting to the
last column or the first column in your table if you
want the titles, totals, or information in those
columns to stand out. Table styles make your table
more attractive and user friendly.
Click in any cell in your table.
The Table tools become
Click the Design tab.
Click the down arrow in the
Table Styles group.
A gallery of styles becomes
Click a style to apply the style to
Click Clear to remove a style
from your table.
Right-click a style.