Chapter 11. Sorting and Filtering Worksheet Data

In this section:

  • “Sorting Worksheet Data Using Single Column and Multicolumn Sorts”

  • “Defining Custom Lists and Sort Using Those Lists”

  • “Limiting Worksheet Data Using Filters”

  • “Guiding Data Entry with Validation Rules”

After you add data to your worksheets, you might want to change the order in which the worksheet rows are displayed. For example, if you have 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 that the most expensive orders are at the top of the list and the least expensive at the bottom. You can also hide any rows that don’t meet your criteria, which is particularly useful if you ...

Get Microsoft® Excel® 2010 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.