One of the most useful features of Excel is sorting a list of data items. Sorting means arranging the data in a sequence, either alphabetically, or chronologically, or numerically. Sorting can be in ascending (increasing) or descending (decreasing) order.
Consider the table shown below, which is the list of Top Ten companies by Market Capitalisation. These figures are not actual figures and are only used for understanding this example. This list is sorted by Rank order. We can sort this list based on other columns, such as Company Name.
Sort Button Sort Dialog Box
To sort a list:
- Select the list (range A1:G11)
- From the menu select Data and on the Ribbon select Sort button. The Sort dialog box appears.
- In the Sort dialog box, select “My data has headers” since the first row in our worksheet is column headings.
- In Sort by select Company Name (Column B), since we want to sort by company name.
- Select order as A to Z since we want to sort alphabetically.
- Click OK button
The list is sorted alphabetically by Company Name. The sorted list is shown below:
When you buy any of these books from this website, I may get a small commission from Amazon. This will NOT increase the cost of books for you but will help me to some extent in covering cost of maintaining this website and providing quality content. Thank you.