Page 147 - Excel 2007 Bible

10_044039 ch06.qxp 11/21/06 10:57 AM Page 104
Part I
Getting Started with Excel
FIGURE 6.8
Removing duplicate rows from a table is easy.
It’s important to understand that duplicate values are determined by the value displayed in the
WARNING
WARNING
cell — not necessarily the value stored in the cell. For example, assume that two cells contain
the same date. One of the dates is formatted to display as 5/15/2007, and the other is formatted to display
as May 15, 2007. When removing duplicates, Excel considers these dates to be different.
Sorting and filtering a table
The Header Row of a table contains a drop-down arrow that, when clicked, displays sorting and filtering
options (see Figure 6.9).
FIGURE 6.9
Each column in a table contains sorting and filtering option.

104