MS Excel Filter Function
MS Excel Filter Function & Filter Formulas
Excel gives you the ability to sort a list of items, names, or numbers. You can select which field or fields you want to use for the sort, and whether to sort in ascending or descending order. The following explains how to sort the First Names in a table.
- Click in the cell you want to use for sorting to make it an active cell. In this example, cell B1 has
- On the Home tab, click the Sort & Filter button
3. Select Sort A to Z. This will sort the list alphabetically by Last Name, since the active cell was in the Last Name column
4. The list is now sorted in alphabetical order by Last Name.