LearnFast.Ninja

How to sort Excel by color 2010

Select the data you want to sort. Click Data then click Sort. Select the color you want to sort by then select where to order then click OK. Note that you can add color by clicking Add Level button.

Step 1: Select the data you want to sort.


Step 2: Click Data > click Sort.


Step 3: Select the color you want to sort by > select where to order > click OK.


Result:


Note: You can add color by clicking Add Level.


Tags

excel

sort