Microsoft Office Tutorials and References
In Depth Information
Working with Tables
duplicate search. Most of the time, you’ll want to select all the columns, which is the default. Click
OK, and Excel then weeds out the duplicate rows and displays a message that tells you how
many duplicates it removed.
Unfortunately, Excel does not provide a way for you to review the duplicate records before
deleting them. You can, however, use Undo (or press Ctrl+Z) if the result isn’t what you expect.
If you want to remove duplicates from a worksheet database that’s not a table, choose
Data➜Data Tools➜Remove Duplicates.
Figure 9-5: Removing duplicate rows from a table is easy.
Duplicate values are determined by the value displayed in the 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/2010, and the other is formatted to display
as May 15, 2010. When removing duplicates, Excel considers these dates to be different.
Sorting and filtering a table
Each column in the Header row of a table contains a clickable control, which normally displays a
downward pointing arrow. That control, when clicked, displays sorting and filtering options.
Figure 9-6 shows a table of real estate listing information after clicking the control for the Date
Listed column. If a column is filtered or sorted, the image on the control changes to remind you
that the column was used in a filter or sort operation.
This workbook, named real estate table.xlsx , is available on the companion
If you’re working with a worksheet database (rather than a table), use Data➜Sort &
Filter➜Filter to add the drop-down controls to the top row of your database. This
command is a toggle, so you can hide the drop-down arrows by selecting that command
again. You can also use Data➜Sort & Filter➜Filter to hide the drop-down arrows in a