Sorting Data

Sorting data is useful for organizing long or short lists of data, from largest to smallest, smallest to largest, making use of custom options, or by column, row, or any combination of these factors.

Quick Sort

The easiest, and quickest, way to sort data in Excel is to use the Quick Sort button in the Data tab. However, there are certain conditions that need to be filled first: whatever selection you have made for sorting, you must ensure there are NO BLANK CELLS. Blank cells will royally screw up any data sorting you want to do. Once you have ensured this is not the case for your data set, select the column you want to sort and click on either the