Custom Sort in Excel 2010

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

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.

cus1.jpg

Step 2

In Home tab click on Sort & filter.

cus2.jpg

Step 3

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

cos3.jpg

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.

cos4.jpg

Step 5

Sorting result will be display.

cos5.jpg

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.