Sorting by Multiple Column in Excel 2010

In this article I am going to explain about sorting by multiple column sort in Excel 2010.
  • 3611

Sorting by Multiple Column in Excel 2010

Multiple column Sorting is the types of sorting technique by which we can sort our data by multiple column for its we need to use custom sort. Example If we want to sort a record first by Name and then after Address then we use Multiple sorting.

To Multiple Column Sorting we have to follow following steps.

Step 1

Open worksheet and select table which we want to sort.

SelectTableExcel2010.jpg

Step 2

In Home click on Sort and Filter and select Custom Sort.

CustomSortExcel2010.jpg

Step 3

After its a Sort Dialog box will be open.

SortDialogBox2010.jpg

Step 4

In this dialog box we will select First sort column name in Sort by and Sort on area we will select sort type on the basis of we want to sort data.

SortSetting2Excel2010.jpg

Step 5

After it we will click on Add level and set second sort column name and click OK.

SortSettingExcel2010.jpg

Step 6

Sort result will be show.

SortResult2010.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.