How to Use Excel Shortcut to Sort Data (7 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes, we need to sort data for different kinds of analysis. There are easy ways for sorting data in Excel. But it can be time-consuming when we have a large dataset. We can use Excel Sort Shortcut for this purpose. Different keyboard shortcuts are available for sorting. Today, we will use Excel Sort Shortcut. These shortcuts will save a lot of time by performing the operations quickly.


Download Practice Book

Download the Practice Book.


7 Ways to Sort Data in Excel Using Shortcut

1. Excel Shortcut for Single Column Sorting

In this method, we will show how we can sort a single column. Here, we will use a dataset of four columns. These are Employee, Working Hour, Region & Salary Column.

Excel Shortcut for Single Column Sorting

Follow the steps below for this method.

STEPS:

  • Firstly, select a cell in the column where you want to sort. We have selected Cell C5.

Excel Shortcut for Single Column Sorting

  • Secondly, press Alt + A S D for descending order. The column will be sorted automatically like below.

Excel Shortcut for Single Column Sorting

  • Thirdly, press Alt + A S A for ascending order. The final output will look like below.

Excel Shortcut for Single Column Sorting

Read More: How to Sort Columns in Excel without Mixing Data (3 Ways)


2. Sort Multiple Columns Using Excel Shortcut

In this procedure, we will use the previous dataset. Here, we will work with multiple columns. We will try to sort our Working Hour & Region column together. Follow the steps below.

Sort Multiple Columns Using Excel Shortcut

STEPS:

  • Firstly, select a cell in your dataset. We have selected Cell C5.

Sort Multiple Columns Using Excel Shortcut

  • Secondly, press Alt + ASS. It will open the dialogue box shown below. Make sure ‘My data has headers’ is selected.

Sort Multiple Columns Using Excel Shortcut

  • Thirdly, change the Sort by menu to your expected column. We have selected Working Hour.

Sort Multiple Columns Using Excel Shortcut

  • Now, select Add Level to insert the second column of your dataset. You can always choose the Sorting criteria and Order from these options.

Sort Multiple Columns Using Excel Shortcut

  • Finally, select OK and it will sort data automatically.

Sort Multiple Columns Using Excel Shortcut

You can see the Working Hour column is sorted in ascending order and then the Region column is sorted in A to Z order.

Read More: How to Sort Multiple Columns in Excel (5 Quick Approaches)


3. Use of Macro to Sort Data in Excel

We can use the VBA feature of Excel to sort our data. After inserting the VBA code, we can use a keyboard shortcut for sorting. We will use the same dataset here.

Follow the below steps:

STEPS:

  • Firstly, go to the DEVELOPER tab and select Visual Basic.

Use of Macro to Sort Data in Excel

  • Secondly, go to Insert in Visual Basic Window and then select Module.
  • Thirdly, type the code in the Module and save it.
Sub MultiColumn()
  With ActiveSheet.Sort
    .SortFields.Clear
    .SortFields.Add Key:=Range("C4"), Order:=xlAscending
    .SortFields.Add Key:=Range("D4"), Order:=xlAscending
    .SetRange Range("B4:E10")
    .Header = xlYes
    .Apply
  End With
End Sub

Use of Macro to Sort Data in Excel

  • Then, go to the Macros in the DEVELOPER It will open the Macro window.

Use of Macro to Sort Data in Excel

  • Now, go to the Options tab of the Macro.

Use of Macro to Sort Data in Excel

  • Now, we will create the shortcut key for our macro. We have selected the “a” key here. You can select any key you want.

Use of Macro to Sort Data in Excel

  • Finally, press Ctrl + A, and the data will be sorted in ascending order.

Use of Macro to Sort Data in Excel

Here, our Working Hour column is sorted in ascending order and then the Region column is sorted in A to Z order.

Read More: How to Sort Data in Excel Using Formula


4. Keyboard Accelerators Shortcut for Sorting in Excel

Keyboard Accelerators are also helpful for sorting datasets in Excel. We will again use the same dataset here. In the following steps, we will demonstrate this method.

STEPS:

  • Firstly, select a cell in the column where you want to sort data. We have selected Cell C5.

Keyboard Accelerators Shortcut for Sorting in Excel

  • Secondly, hit the Alt key and some letters will appear on your screen.

Keyboard Accelerators Shortcut for Sorting in Excel

  • Thirdly, press the SA key and your data will be sorted in ascending order.

Keyboard Accelerators Shortcut for Sorting in Excel

  • Now, if you press the SD key, the data will be sorted in descending order.

Keyboard Accelerators Shortcut for Sorting in Excel

  • Next, for custom sort, press the SS. It will open the Sort window.

Keyboard Accelerators Shortcut for Sorting in Excel

  • Then, add level and select the columns you want to like Method-2 and press OK.

Keyboard Accelerators Shortcut for Sorting in Excel

  • Finally, it will sort multiple columns together like the picture below.

Keyboard Accelerators Shortcut for Sorting in Excel


Similar Readings:


5. Sort in Excel Using the Home Tab

We will use the Home Tab as a shortcut to sort data this time. This method has some similarities with the previous methods. So, we will use the same dataset here.

Follow the steps below.

STEPS:

  • Firstly, select a cell in the column where you want to want. We have selected Cell C5.

Sort in Excel Using the Home Tab

  • Secondly, press Alt + H and some letters will pop up on your screen.
  • Thirdly, look at the top right corner, you will find some letters like below.

Sort in Excel Using the Home Tab

  • Now, press the S key on your keyboard. A drop-down menu appears.

Sort in Excel Using the Home Tab

  • Finally, press ‘S’, and your data will be sorted in ascending order.

Sort in Excel Using the Home Tab

You can also sort your data descendingly by pressing ‘O’ and perform custom sort by pressing ‘U’.

Read More: How to Sort Excel Tabs in Ascending or Descending Order (2 Ways)


6. Use of Menu Key Shortcut for Sorting

Using Menu Key is another way to sort data. We will sort the Working Hour column of our previous dataset. Follow the steps to know this method.

STEPS:

  • Firstly, select Cell C5.

Use of Menu Key Shortcut for Sorting

  • Now, press ‘Menu key + OS’, and the column will be sorted ascendingly.

Use of Menu Key Shortcut for Sorting

  • Next, if you press ‘Menu key + OO’, the column will be sorted descendingly.

  • Finally, for custom sort, press ‘Menu key + OU’ and a window open like Method-2. You can select multiple columns here for sorting.

Related Content: How to Use Advanced Sorting Options in Excel


7. Use of Filter Drop Down Menu Shortcut for Sorting

We can also use the Filter option for sorting easily. In this method, we need to apply the filter in our dataset first. We will apply this method in the same dataset.

STEPS:

  • Firstly, select any cell of your dataset. We have selected Cell C5.

Use of Filter Drop Down Menu Shortcut for Sorting

  • Secondly, press Ctrl + Shift + L.This will apply the filter to our dataset.

Use of Filter Drop Down Menu Shortcut for Sorting

  • Thirdly, select the header of the column where you want to sort data.

  • Now, press Alt + Drop Down arrow + S. This will sort the column ascendingly.

  • Now, press Alt + Drop Down arrow + O to sort the column descendingly.

  • Finally, press Alt + Drop Down arrow + T to sort the data according to colors.

Read More: How to Sort Drop Down List in Excel (5 Easy Methods)


Conclusion

Sorting data is necessary for the representation of our dataset. It helps us to get a clear view of our dataset. We have an easy excel sort shortcut here. Hope these methods will help you to find solutions to your problem. Last of all, if you have any queries or suggestions, feel free to comment below.


Related Articles

Mursalin Ibne Salehin

Mursalin Ibne Salehin

Hi there! This is Mursalin. I am an Excel and VBA content developer at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo