- slide 1 of 8
Excel 2013’s Sort feature offers a powerful tool to arrange data the way you want it displayed. You probably already know how to sort based on values in a column or row and use multiple criteria for complex sorting, but Excel goes beyond these intuitive methods.
For example, you might have a color-coordinated system where cells appear blue or green depending on the values therein. Or maybe your accounting method displays negative values in a red font; if you kept the negative sign, sorting based on values isn’t a problem, but if you didn’t, you’ll need color sorting.
1. Highlight the cells containing the data you want sorted. The color values can be fill colors or font colors and can be in a single column or entire rows; it doesn’t matter.
- slide 4 of 8
- slide 6 of 8
Note: You can add addition levels to specify where each color appears. Although the order is always “on top” or “on bottom,” sorting begins on the first criteria, then the second, and so force. So for example, listing five colors, each “on top” sorts them by the first color configured, then the second, etc.
6. Click OK to sort the data.