|
Introduction | Standard Toolbar | Formatting Toolbar | Navigating | Simple Formulas
Rows & Columns | Sorting | Cell Formatting | Charts
Sorting:
One of Excel’s powerful features is its ability to sort, while still retaining the relationships among information. For example, let’s take our student grade example from above. What if we wanted to sort the grades in descending order? First, let’s select the information we want to sort.
Now let’s select the “Sort” option from the “Data” menu.
A new window will appear asking how you would like to sort the information. Let’s sort it by the average grade, which is in Column E; be sure to set by “Descending” order. If there were other criteria you wished to sort by as secondary measures, you could do so; let’s select “Then by” as “Grade 3” just for the practice of doing so (“Descending” order, as well).
Excel will sort your information with the specifications you entered. The results should look something like this:
next >>
|
