Office 2013 All-In-One Absolute Beginner’s Guide

20. Sorting Data

In This Chapter

• Sorting Excel Data

• Performing a Quick Sort

• Fixing Sort Problems

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

Sorting Excel Data

Excel lets you sort your cell data in a variety of ways: by value, cell color, font color, or conditional formatting.

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 ...