Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Communicating Data Visually
When you select a cell in a table, you can use the commands located on the Table
The cells contain background color and text color formatting. This formatting is
Each column header contains a Filter Button — a drop-down list that you can
use to sort the data or ﬁ filter the table to display only rows that meet certain
criteria. Displaying the Filter Button is optional.
You can create easy-to-use Slicers to simplify ﬁ ltering data.
If the active cell is within the table, when you scroll down the sheet so that
the header row disappears, the table headers replace the column letters in the
Tables support calculated columns. A single formula in a column is automatically
propagated to all cells in the column.
Tables support structured references. Instead of using cell references, formulas
can use table names and column headers.
The lower-right corner of the lower-right cell contains a small control that you
can click and drag to extend the table’s size, either horizontally (add more
columns) or vertically (add more rows).
Selecting rows and columns within the table is simpliﬁ ed.
Most of the time, you’fill create a table from an existing range of data. However, Excel also
enables you to create a table from an empty range so that you can ﬁ fill in the details later.
The following instructions assume that you already have a range of data that’s suitable for
1. Make sure that the range doesn’t contain any completely blank rows or
columns; otherwise, Excel will not guess the table range correctly.
2. Select any cell within the range.
3. Choose Insert ➪ Tables ➪ Table (or press Ctrl+T). Excel responds with its Create
Table dialog box, shown in Figure 19.3. Excel tries to guess the range, as well as
whether the table has a header row. Most of the time, it guesses correctly. If not,
correct the range in the Where is the data for your table? Text box.
4. Click OK. The range is converted to a table (using the default table style), and the
Design tab of the Ribbon appears.