O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

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 14. Sorting Data

In this chapter

Introducing the New Sort Dialog 288

Using Specialized Sorting 289

One-Click Sorting 294

Sorting Randomly 295

Sorting data is one of the key capabilities of a spreadsheet program such as Excel. With a click of the mouse, you can rearrange data so that it is presented in an alphabetical sequence or in a sequence with the largest numbers at the top or bottom of a list of data.

One of the considerations when sorting is what happens when there are ties in the column upon which the sort is based. If you have a database of product sales and sort the data by the product field, it is likely you will have many rows with identical products. In that case, you can specify a secondary sort criteria. You might want to ...

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