Skip to content

3 Ways to Sort Your List in Excel

Here are three ways that you can sort a list of values in Excel.

  • Use the keyboard shortcut – ALT + H + S + S
  • Add a filter and use the filter button
  • Use the SORT function

Keep reading to learn more about each method.

Method 1 – Use ALT + H + S + S

This is probably the quickest way to sort a list of values in Excel.

All you have to do is press the ALT key and then press H, S, and S in succession.

Since this shortcut uses the ALT key, you do not press all the keys at once. Instead, you press them one after the other.

Method 2 – Add a Filter

The second thing you can do to sort your list is to add a filter.

To add a filter to your list, select the list and go to Home Sort & Filter > Filter.

You will now have a filter button at the top of your list.

Just click on this button and select the sorting option you which to use.

Method 3 – Use the SORT Function

One of the newest functions introduced in Office 365 is the SORT function. You can read all about this function in the article below.

To sort your list using the SORT function, pick a new location for your sorted list and enter the following formula.

This will take your current list and return the list sorted in the new location.

See It In Action

Check out the video below to see all three sorting methods in action!

This Post Has One Comment

  1. I saw this YouTube short and I knew about the filter, but I didn’t know about the other two options. It’s so nice to be able to sort without creating a filter with the short cut or to sort the data in a new location without altering the original data. I can’t tell you how helpful that has been!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top