Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Tables and Worksheet Databases
A table example
Figure 9-2 shows the employee worksheet database after I converted it to a table, using
Figure 9-2: A worksheet database, converted to a table.
What’s the difference between a worksheet database and a table?
h Activating any cell in the table gives you access to a new Table Tools context tab on the
h The cells contain background color and text color formatting, applied automatically by
Excel. This formatting is optional.
h Each column header contains a button that, when clicked, displays a drop-down list with
sorting and filtering options.
h 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.
h Tables support calculated columns. A single formula entered in a column is propagated
automatically to all cells in the column.
h You can easily add a summary row at the bottom that summarizes the columns.
h Tables support structured references. Rather than using cell references, formulas can use
table names and column headers.
h When you move your mouse pointer to the lower-right corner of the lower-right cell, you
can click and drag to extend the table’s size, either horizontally (add more columns) or
vertically (add more rows).
h Excel is able to remove duplicate rows automatically.
h Selecting rows and columns within the table is simplified.