Excel Sort on Multiple Columns

Use the Sort Range activity to sort data from up to three columns in Excel.

About the Excel Sort Range Activity

The Sort Range activity can filter and organize data from up to three columns in an Excel table.

Use Case Example and Procedure

For example, you have a table with no more than three columns and multple rows, and want to organize the data by column. You can use the Sort Range activity to organize the data first in column A, then in column B, and then column C.

You will need to set up your automation as follows:

  • Add the first Sort Range activity for column A, which will filter and sort the range in column A. Click the activity to define the parameters in the right-hand panel. Enter the rangeDefinition for the whole table, for example A1:C16. Under column1 enter the title of your first column, and leave the other two blank.

  • Drag and drop the second Sort Range activity for column B. Click the activity to define the parameters in the right-hand panel. Enter the rangeDefinition for the whole table. Under column1 enter the title of your first column, and under column2 enter the title of your second column, leave the thirs column blank.

  • Drag and drop the third Sort Range activity for column C. Click the activity to define the parameters in the right-hand panel. Enter the rangeDefinition for the whole table. Under column1 enter the title of your first column, and under column2 enter the title of your second column, and under column3 enter the title of your third column.

Your automation should resemble this:

Results

Once the automation is executed, your data will be filtered and organized first in column A, then B, and then C, as follows: