How to Sort By Color in Excel 2013

Adding a fill color to a row of information in Excel 2013 allows you to visually identify a particular set of information more easily. If you establish a color coding system for how you select these fill colors, it can allow you to do some pretty helpful sorting.

So if you have a spreadsheet that contains rows with fill colors, you can follow our short tutorial below to learn how to sort by color in Excel 2013.

Group Cells by Color in Excel 2013

This tutorial will assume that you have a spreadsheet with rows of cells that have the same fill color. Performing the steps below will group all of the rows with the same color, allowing you to view each group of rows together. Any rows without a fill color will also be grouped together.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Select all of the row numbers that you want to sort at the left side of the screen.

select the rows to be sorted

Step 3: Click the Home tab at the top of the window.

click the Home tab

Step 4: Click the Sort & Filter button in the Editing section of the navigational ribbon, then click Custom Sort.

how to sort by color in excel 2013

Step 5: Click the drop-down menu next to Sort by, then select the column that you want to use as the sort criteria within the sorted colors.

click the sort by drop-down menu

Step 6: Click the drop-down menu under Sort On, then click Cell Color.

click the sort on drop-down menu

Step 7: Click the drop-down menu under Order, then select the color that you want to be displayed on top.

click the order drop-down menu

Step 8: Click the Add Level button at the top of the window.

click the add level button

Step 9: Repeat steps 5-8 for the rest of the colors in your spreadsheet.

repeat steps 5-8 for each color in the spreadsheet

Step 10: Click the OK button at the bottom of the window when you are done to execute the sort.

the final, sorted spreadsheet

Now that you know how to sort by color in Excel 2013, you can use this feature in the future as a way to manage spreadsheet data where fill colors have been used as part of that data’s value.

Is there too much information in one of your rows, and you want to be able to see all of it? Learn how to expand a row in Excel 2013 and increase your row size.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy