Microsoft Office Tutorials and References
In Depth Information
Figure 9-2: A list, converted to a table.
Apart from cosmetics, what's the difference between a list and a table?
• Activating any cell in the table gives you access to the Table Tools contextual tab on the Ribbon.
• You can easily add a summary row at the bottom that summarizes the columns. When a summary row is
present, Excel creates summary formulas automatically.
• The table is assigned a name automatically (for example, Table1 ), and the range name adjusts automatically
when you add or remove rows. You can change the name of the table using Formulas ⇒ Defined
Names ⇒ Name Manager, but you cannot delete the name or change its definition. Note that the range name
definition does not include the Header row or Total row.
• The cells contain background color and text color formatting, applied automatically by Excel. This format-
ting is optional. The formatting is done by named table styles, which are customizable and tied to the work-
• Each column header contains a Filter button that, when clicked, displays a drop-down list with sorting and
filtering options. You can get this same functionality in a list by choosing Data ⇒ Sort & Filter ⇒ Filter.
• You can add “Slicers” to make it easy for novices to filter the table. This is a new feature in Excel 2013.
• If you scroll the worksheet down so that the Header row disappears, the table headers replace the column
letters in the worksheet header. In other words, you don't need to “freeze” the top row to keep the column
labels visible when you scroll down.
• Tables support calculated columns. A single formula entered in a column is propagated automatically to all
cells in the column.