Sorting by color font, color background, or icon


show more Sorting by color font, color background, or icon provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Sorting by color font, color background, or icon

A new feature in Excel 2007 is the ability to sort data on the basis of cell color or font color or even cell icon. In this particular worksheet, as I start to scroll down, we would recognize there is a pink row in Row 16. There is 21 and 26 have green, green color, so does Row 37. Perhaps there are some colors there too. And the colors might have been put in there for a variety of reasons, but we do want to rearrange our data. We want to sort the rows here by putting the colors together.

Maybe we want all the greens to be at the top of the list. You also notice in this worksheet as I scroll to the right that in Column J there are icons placed here based on the salary. Now if we wanted all the green arrows together, we could easily sort by the values themselves, but also what we could do here is not be showing the actual salary number. In other words, just the icon. So at different times, you might want to sort by icon as well. So let's tackle first the issue of sorting by color, color...

Sorting by color font, color background, or icon
Video duration: 3m 57s 1h 32m Appropriate for all

Viewers:

Sorting by color font, color background, or icon provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...