Sort by 2 Columns in Excel 2016

I want to sort the keyword research data which is huge like 2500+ keywords. I want to sort the data in Excel 2016 by 2 Columns. How to do it?

 

To sort data in Excel 2016 by two columns, follow these steps:

1. Select the range of cells that you want to sort.
   
   
2. On the "Home" tab, click the "Sort & Filter" button.
   
   
3. From the dropdown menu, select "Custom Sort".
   
   
4. In the "Sort dialog box", select the first column that you want to sort by in the "Sort by" dropdown menu.
   
   
5. In the "Then by" dropdown menu, select the second column that you want to sort by.
   
   
6. Use the "Order" dropdown menus to specify the sort order for each column (ascending or descending).
   
   
7. Click the "OK" button to sort the data by the two selected columns.
   

 

Alternatively, you can use the following formula to sort the data by two columns:

1. Select a cell in the row below the column headings.
   
   
2. Type the following formula:

=SORT(A2:C10, 1, TRUE, 2, TRUE)

 

To sort data in Excel by multiple columns:

1. Select the cells in the range of data you want to sort.
2. Click the "Sort & Filter" button in the Editing group on the Home tab.
3. Click "Sort Oldest to Newest" or "Sort A to Z" to sort by the first column.
4. Click "Add Level" and select the second column you want to sort by.
5. Choose whether you want to sort the second column in ascending or descending order.
6. Click "OK" to sort the data.

Alternatively, you can use the "Sort" button in the Data tab of the ribbon. This will give you the option to sort by multiple columns at once.

You can also use the "Sort" dialog box to specify the sort criteria, sort order and the range of cells to be sorted.