Custom Sort in Excel 2010

In this article I am going to explain about custom sort in Excel 2010.
  • 2162

Custom Sort in Excel 2010

Custom sort is the properties by which we can sort to data by cell color, cell value, font color and icon basis.

To Custom sort we have to follow following steps.

Step 1

Open worksheet and select cell range where we want to sort to value.


Step 2

In Home tab click on Sort & filter.


Step 3

In sort & filter select Custom sort then a Sort dialog box will be open.


Step 4

In sort dialog box we we set the custom sort and click OK. // In this example we will set sort on the basis of Cell color.


Step 5

Sorting result will be display.


Ask Your Question 
Got a programming related question? You may want to post your question here


More Articles

© 2018 DotNetHeaven. All rights reserved.