how to sort multiple columns in excel using vba

Otherwise, left-out columns will be as it is. Step 6: By default, orders selected “Oldest to Newest.” Our objective is to sort from oldest to newest.Ĭlick on “OK” to sort.Step 5: Select the “Date” header from the second layer.Step 3: Select a “Country” header in the first drop-down list.

So, we want to sort the data country-wise first and then date-wise (oldest to newest). We have a sales table country-wise on different dates. Next, they will sort by “Product” and finally by “Units Sold” (largest to smallest). It will sort the “Units Sold” column from the largest to the lowest value.įirstly, it will sort the data based on the “Segment” column.

Step 9: It will sort the layers alphabetically.

Step 8: The “Order” will default to “Smallest to Largest.” Under “Order,” click on the dropdown list and select “Largest to Smallest.”.

Step 7: Select the “Units Sold” header from the third layer.

Step 6: Click “Add Level” to add the third layer.

Step 5: From the second layer, select the “Product.”.

Step 4: Click “Add Level” to insert one more layer.

Step 3: First, select the “Segment” heading.

Step 2: Press “ALT + D + S.” (shortcut key to open the SORT box).

(We are using the same data from the previous example) Assume we want to sort the data segment-wise, product-wise, and units sold from largest to smallest. Previously, we sorted the data country-wise. In this example, we will explain the multi-level sorting process. In the previous example, we have learned single-level sorting.

Click on “OK.” It will sort the data country-wise alphabetically from A to Z.

The final “SORT” dialog box should look like this.

Finally, select the “Order.” You can sort A to Z, Z to A, and a custom list here.

Click on “Sort On.” Here, we can sort based on values, cell color, font color, and conditional formatting icon.

Click on the “Sort by” dropdown list and select the word “Country.”.

Otherwise, your header will be treated as the data only. If this box has ticked means, the selected data has headers.

Make sure the “My data has headers” checkbox has been ticked.

Go to the “Data” tab > “Sort.” The shortcut key to open the “Sort” option is “ALT + D + S.”.

Next, you can use the shortcut key to select the entire data, select the first row, and then click “Ctrl + Shift + Down Arrow.”

First, select the data that we want to sort.

Below are the steps used for single-level data sorting:

How to sort multiple columns in excel using vba