Microsoft® Office Excel® 2007 Plain & Simple

Chapter 11. Sorting and Filtering Worksheet Data

In this section:

• Sorting Worksheet Data

• Define Custom Lists and Sort Using Those Lists

• Limit Worksheet Data Using Filters

• Guide Data Entry with Validation Rules

• Getting More out of Advanced Filters

• Finding Unique Values in a Data List

• Finding Duplicate Values in a Data List

After you’ve added data to your worksheets, you may want to change the order in which the worksheet rows are displayed. For example, if you had a worksheet listing orders for a week, you might want to list the orders for each customer, or perhaps reorder the rows in your worksheet so the most expensive orders were at the top of the list and the least expensive at the bottom. You could also hide any rows that didn’t meet your criteria, ...