O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

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 7

Sorting and Filtering Data

Perform a Simple Sort or Filter

You can make a range easier to analyze by sorting it based on a column’s values. You can sort the data using either an ascending sort, which arranges the values alphabetically from A to Z or numerically from 0 to 9, or a descending sort, which arranges the values from Z to A or from 9 to 0.

You can also analyze data by filtering it to show only the items you want to work with. The easiest way to filter a range is to use the Filter buttons, each of which presents you with a list of check boxes for each unique value in a column. You filter the data by activating the check boxes for the items you want to see.

Perform a Simple Sort or Filter

Sort a List

Click a cell in the ...

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