how to add a custom sort list in excel for mac

And you need to sort on more than one field when the first field contains duplicate values and you want to determine how the records with duplicates are arranged.

If you dont specify another field to sort on, Excel just puts the records in the order in which you entered them.).

Say that you have a database that contains several people with the last name Smith, Jones, or Zastrow (as is the case when you work at Zastrow and Sons).

If you see that you sorted the database on the wrong fields or in the wrong order, click the Undo button on the Quick Access toolbar or press CtrlZ to immediately restore the data list records to their previous order.

You can, however, use the Sort feature to sort a cell selection that doesnt have such a header row.

In that case, you need to specify the sorting keys by column letter, and you need to be sure to deselect the My Data Has Headers check box to remove its check mark in the Sort dialog box.

He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.

Each Element has information that is unique to it, such as its Symbol and Atomic Number.

But each element also belongs to other categories, such as its Phase at STP (i.e., whether it is a solid, liquid, or gas in a room at standard temperature and pressure) and its Element Category on the period table.

Start by selecting the column (you can include the header row if your data has one).

In this example, we will sort from the lowest to highest numerical value using the Sort A to Z feature.

Lets examine the results of the Continue with the current selection option, first.

This could be problematic if you wanted to sort all of the columns.

So, before moving on, look at some of the rows to see if they make sense.

In this case, it is obvious that the other columns have not been sorted because Hydrogen, the element with the lowest Atomic Number, is shown as having the Atomic Number of Lead.

This means it will be the second column used to sort the data.

We will choose the Element Category as the second level so that the gasses are sorted by their category and noble gasses will appear higher on the list than the reactive gasses.

There are a variety of options, but we will use the Cell Values option.

This means that the Element values in each Element Category will be sorted alphabetically so that the noble gas Argon will come before the other noble gas, Neon.

There are a few options, but for this example, we will choose the default A to Z sort order.

The sort order was first by Phase at STP, then Element Category, and then by Element.

You can see that the Phase at STP column is sorted alphabetically and within each Phase at STP type, the Element Category values are sorted alphabetically.

And finally, the Element values are sorted alphabetically within each Element Category type.

Excel will not warn you that you may be overlooking columns when you use the Custom Sort feature.

Since we launched in 2006, our articles have been read more than 1 billion times.

How To Add A Custom Sort List In Excel For Mac