Microsoft Office Tutorials and References
In Depth Information
Working with Table Styles
10. In the Clipboard group, double-click the Format Painter button
Be sure to double-click the
Format Painter button so
you can paste the copied
format into multiple cells.
11. Click cell A21 . All of the formats in the range A6:K19 are applied to the cell.
12. Click cell A36 . Once again, all of the formats are applied to the selected cell.
13. In the Clipboard group, click the Format Painter button
to turn off the Format
14. Scroll up to the top of the worksheet and select cell . Figure 2-28 shows the A1
formatted values for the first table.
Figure 2-28
Formatted table
Working with Table Styles
You can identify a range as an Excel table, which makes available tools designed for
analyzing tabular data, such as the ability to sort data, transfer data to and from an external
fi le, and fi lter the data to show only those rows that match specifi ed criteria. Excel tables
can include optional elements such as a header row that contains titles for the different
columns in the table, and a total row that contains formulas summarizing the values in
the table’s data. You can also apply a table style, which specifi es formats such as font
color, fi ll color, and so on for each of these elements. Formatting an entire table with
a table style is more effi cient than formatting individual cells in the table. (This tutorial
covers only the styles associated with Excel tables.
In addition, using a table style ensures that the table’s formatting refl ects any changes
made to the table, such as adding or deleting table rows or columns. For example, many
tables display alternate rows with different fi ll colors. This banded rows effect makes
the data easier to read, especially in large tables with many rows. You could create the
banded rows effect by applying a cell style with a background fi ll to every other row
in the table; but if you later add or delete a row from the table, the banded rows effect
might be lost. A table style, on the other hand, applies alternating row colors to the entire
Excel table and adjusts the banded rows effect as needed if you add or delete rows. This
is because a table style treats the table as a single object rather than a collection of cells.
Figure 2-29 shows the banded rows effect applied both manually and with a table style.
Applying a table style also
marks the range as an
Excel table.
Search JabSto ::

Custom Search