« SHARKK Mouse Review | Main | Arduino Kit in a Briefcase (with Harder to Lose Pieces) »

Sort by color in Excel

Sort by colorI sort Excel data by value all the time - alphabetically, numerically, and in ascending and descending order.

I also love to to color code cells for a quick visual cue--- so, how did I not know that sorting by cell color is also an option?  (Thanks, Cindy, for cluing me in!)

Here's how:

  1. Select the range of cells you'd like to sort
  2. On the Home tab, select Sort & Filter -> Custom Sort...
  3. For "Sort On", select Cell Color

Sortoptions

Posted by Kerri on Feb. 5, 2015 in How Tos , Microsoft Office | Permalink

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Post a comment