![how to sort multiple columns in excel 2003 how to sort multiple columns in excel 2003](https://docs.microsoft.com/en-us/sql/reporting-services/report-builder/media/groupproperties-updated.png)
To learn how to do this read: How to sort Rows horizontally left to right instead of Columns vertically top to bottom in Excel You can sort the data on columnar basis or row basis.You can also use shortcut keys Ctrl+Arrow Up to move up and Ctrl+Arrow Down to move level down. If you want to change the order of criteria application then you can do that simply by selecting each level and clicking arrow up or arrow down to move it above or below other levels.Once done excel will sub-sort the data in the sales column for each city by showing highest sale first. Therefore, excel will first sort excel’s data on the basis of city. As we have two levels city criteria first and sales criteria second. How multi level sort works:Įach level acts as sort run in excel that are executed in the order we specify i.e. Click OKįollowing animation walks you through all the six steps discussed above:Īnd here you have data sorted by cities in the order you specific in your custom list and then the sales reported in descending order for each city. Keep “values” selected in the sort on drop down. Step 6: In the level just created, from then by drop down select sales and from order drop down select largest to smallest. This will add another level of sort or simply criteria. Step 5: Click Add level button at the top in the sort dialogue box. From this make the selection of custom list we have already created. Step 4: Custom list dialogue box will pop up. To learn how to make custom lists read: Custom Autofill series and Custom sorting with Custom lists in Excel
![how to sort multiple columns in excel 2003 how to sort multiple columns in excel 2003](https://www.asap-utilities.com/screenshots/menu/en_us/58.png)
Don’t change sort on drop down selection and keep values selected. Step 3: In the sort dialogue box that appears, from the sort by drop down select City and from the order drop down select custom list. Step 2: In the ribbon above click Data tab > Sort and Filter group > Sort button Either make the selection out of range of data or have an active cell within specific range of cells. Step 1: Consider the data that you want to sort.