Cookies help us deliver our services. By using our services, you agree to our use of cookies.
Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to sort data by color in excel?

When you using a worksheet, sometimes you may fill the rows or cells with various colors to make the worksheet much readable. And sometimes you want to sort the cells by color in Excel. In this case, you can use the sort function to sort the data by color quickly as follows:


1. Select the range that you want to sort the data by color.

2. Click Data > Sort, and a Sort dialog box will appear, see screenshot:

doc-sort-by-color1

3. Then click Sort by drop down list, select the data that you sort, and then click Values drop down list, chose Cell color, then click no cell color drop down list, select the color you would like on top.

4. Click Add Level to add additional lines to specify the order of the remaining colors. See screenshot:

doc-sort-by-color2

5. Then click OK button. You will get the following result:

doc-sort-by-color3



Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 300 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Neda · 1 months ago
    How is the auto-sorting some columns by special color in one column?
  • To post as a guest, your comment is unpublished.
    nik · 3 months ago
    helped alot. thanks.
  • To post as a guest, your comment is unpublished.
    Ahmed · 7 months ago
    This helped me to do what I wanted. Will love to say, thanks!
  • To post as a guest, your comment is unpublished.
    Adrian · 2 years ago
    I know how to do it using the computer. How about sorting cells by their colour in the Microsoft excel in the android phone app?
  • To post as a guest, your comment is unpublished.
    LARRY · 2 years ago
    This is was very helpful! It's exactly what I needed to do. I had no idea it was possible until I found your website.