![]() ![]() ![]() We know how to sort and alphabetize by a single column. The sort buttons work on numerical values as well as text! Alphabetization by multiple columns In this case, we've sorted by our sales values in descending order. For example, what if, rather than alphabetizing our list by customer, we wanted to sort it by the Sales amount to find the highest- and lowest-value orders in our data set? Doing so is easy: simply select a cell within the Sales column (we use E2 in the example below) and press the sort descending button again: Let's say we actually want to sort by something else. ![]() If it does, only the portion of your data above the blank row(s) will be sorted this can lead to confusion on your part. When you alphabetize lists in Excel, it's very important to ensure that the data set with which you're working doesn't have any blank rows. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |