O'Reilly logo

Microsoft® Excel® 2010 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 work with a large ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required