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:
Recommended Productivity Tools for Excel/Office
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:
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:
5. Then click OK button. You will get the following result:
Recommended Productivity Tools
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
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...
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 months agoHow is the auto-sorting some columns by special color in one column?
To post as a guest, your comment is unpublished.· 3 months agohelped alot. thanks.
To post as a guest, your comment is unpublished.· 7 months agoThis helped me to do what I wanted. Will love to say, thanks!
To post as a guest, your comment is unpublished.· 2 years agoI 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.· 2 years agoThis is was very helpful! It's exactly what I needed to do. I had no idea it was possible until I found your website.