How to Make Excel 2010 Sortable List

This tutorial will show you how to make excel sortable list so you can easily rearrange any data in your spreadsheet.


Step # 1 – Highlighting the Column

Start Excel and load the sheet that has the data that you want to make a sortable list from. In this case we have an address book and we are going to be making a sortable list from the “Last name” column. Click on the “B” at the top of that column to highlight it.

Selecting the column for sorting

Step # 2 – Adding a Filter to the Column

Now, navigate to the “Data” tab in the main bar at the top of the screen. Under the “Sort & Filter” section, click on the image that looks like a funnel, it is labeled “Filter”. You will notice that next to the “Last Name” text in cell “B1” a drop down arrow has appeared.

Using the Filter option

Step # 3 – Testing the Sort Functionality

Click on this drop down arrow and you will be presented with a few options that will allow you to sort the data in various ways – this is how to make excel sortable list. To test this functionality click on the top option, “Sort A to Z”. A window will appear and you need to select the “Expand the selection” option and click “Sort”. The window will close and the data in the sheet will have been sorted into alphabetical order based on last name.

Choosing to sort alphabetically