One of the first features that many users begin using is the ability to sort data in Excel. Being able to automatically have your data displayed in a specific order, whether that be number, alphabetical or date order, is a huge time saver. Excel allows you to sort by one column at a time or multiples.
The Sorting buttons can be found in a wide variety of locations within Excel. Which one you use really depends on your personal preference.
- Home tab – access the Sorting options through the Sort & Filter drop-down menu to the right hand side of the Ribbon.
- Data tab – The Sort and Filter functions have their own dedicated group on the Ribbon for direct access.
- Right Mouse Click – The right-mouse click gives you many shortcut options including the Sort menu
- Quick Access Toolbar – I always have the sort A-Z and sort Z-A buttons up on my Quick Access toolbar. Find out how to add them to yours here.
Let’s have a look at how we can sort data in Excel.
Sort data alphabetically in Excel
- Open Microsoft Excel
- Open a workbook which contains data you wish to sort
- In this first example, I want to sort a list of names into alphabetical order from A to Z
- Place your cursor in ANY cell within the column you wish to sort, bearing in mind it needs to be placed BELOW the heading as shown in my example:
TIP: You do not need to highlight the area first.
- Select the Data tab and choose if you wish to sort A to Z or Z to A or locate the sort buttons in your preferred location which is outlined at the top of this article.
- The data will now be sorted into alphabetical order
- Click into a different column, in my example I’ll now click into the First Name column
- Repeat the process to change the sort order of your data
Sort by two columns – Custom Sort
Now that you’ve seen how to sort by one column at a time, let’s look at how you can sort by multiple columns. Let’s use my data as an example. I want to have all my staff listed in alphabetical order by their Office location. I have 18 staff members within each Office location. I’d also like to have everyone within each OFFICE to be displayed in alphabetical order by their Last Name. How can I tell Excel that I want it to sort by BOTH of these columns?
- Place your cursor in ANY cell within the data area
- Select the Data tab and click the Sort button
- The Sort window will appear:
- You will already see the previous sort you performed listed, we want to add a second sorting option so that once Excel had sorted the first set of data, it will then go ahead and sort based on the second criteria
- I need to change my sort order so that the first sort performed is the Office column
- From the options click the Add Level button
- The second sorting level will be displayed
- From the second level choose the next column you wish to sort. E.g. for mine I am going to choose Last Name
- Now click OK
- The data will now be sorted by the first column you chose, e.g. Office and then for duplicate records within that data set you will then have all staff listed in order by Last Name.
The process is the same regardless of whether you want to sort text, numbers, currency or dates.
I hope this helps you with learning how to sort data using Microsoft Excel. Comment below if you have any questions.