Скачать или смотреть How to Make Excel 2016 Sortable List

This tutorial will show you how to create a list that is sortable in Excel

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.

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 "A1" a drop down arrow has appeared.

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.