Select Page

If you’ve never sorted cells by color before, watch Excel Video 382. You’re probably used to sorting cells alphabetically or numerically, but did you know you can sort by the cell color, the font color, or the cell icon? Excel makes it easy. Watch how Excel goes through your sort column to present all of your color options and make sorting by colors a breeze.
One of the ways I’ve used sorting by color is to filter a table to get just the data I need with multiple levels of complex filters. Once I have the filters in place, I’ll change the cell color or the font color to keep track of my filtering. When I need to see which cells I’ve filtered, it’s easy to either sort or filter by color. We’ll look at filtering options next. Thanks for watching.