Microsoft Office Tutorials and References
In Depth Information
Working with Table Styles
Banded rows in a table
after deleting a row from a
table formatted manually,
the banded effect is lost
after deleting a row from a table
formatted with a table style, the
table formatting adjusts to keep
original table with banded rows
Tom wants you to format the sales data in the Monthly Sales worksheet as Excel
tables. First, you’ll apply a table style to the units sold in 2011 data.
To apply a table style to the 2011 sales data:
1. Select the range B6:K19 .
2. In the Styles group on the Home tab, click the Format as Table button, and then
click Table Style Medium 2 (the second style in the first row in the Medium section).
The Format As Table dialog box opens, confirming the range you selected for the
table and whether the table includes header rows.
3. Verify that the range is =$B$6:$K$19 and then verify that the My table has
headers check box contains a check mark to include the text labels in the table.
4. Click the OK button to apply the table style to the selected range, and then click
cell to deselect the range. See Figure 2-30. A5
Range formatted with a table style
click to apply a table style