O'Reilly logo

Using Microsoft® Excel® 2010 by Bill Jelen, Tracy Syrstad

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

7. Sorting

This chapter will show you the various ways you can sort your data, even by color.

Sorting data is a significant capability in Excel, allowing you to view data from least to greatest, greatest to least, by color, or even by your own customized sort listing. This chapter shows you the variety of ways you can sort your data in Excel.

Preparing Data

Your data should adhere to a few basic formatting guidelines to make the most of Excel’s sorting capabilities:

• There should be no blank rows or columns. The occasional blank cell is acceptable.

• Every column should have a header.

• Headers should be in only one row; otherwise, Excel gets confused and is unable to find the header row on its own.

Sorting in the Web App

The sorting capabilities ...

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