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.


Step 2

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


Step 3

After its a Sort Dialog box will be open.


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.


Step 5

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


Step 6

Sort result will be show.


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


More Articles

© 2020 DotNetHeaven. All rights reserved.