To get fancy sort options in Excel with little to no work, try out Excel filters. Here’s little a spreadsheet tutorial to get you started:
To activate filters, click on any header label in your table, go to the Data tab or menu, and click the filter option (a gray funnel icon in Excel 2007+) or auto filter option (Excel 2003). Now dropdown arrows should appear to the right of all of your column labels.
Click the down arrow on any column header and check out the options that are available. The first two options will be sorting ascending (A-Z) and descending (Z-A).
Sort Ascending Example.
The following table is sorted by the Manager column. If you choose to sort by the Model column, you will be able to quickly see groupings by model as in the second screenshot.
Filters give you the ability to to quickly find a row or group of rows based on your filter criteria. The filter dropdown will usually show a list of values in the column that you can choose from . This is really cool and magical – some programs would require you to write SQL code in order to find rows that match your criteria. No SQL knowledge is required with Excel Filters! Check out this example….
Filter by Phone Example.
For the Phone column in this table, we can chose to display only the rows that have (Blanks) in the the Phone column; only the rows that have an ‘x’ in the Phone column; or we can (Select All).
So if we check the filter for only values that are ‘x’, we will see only employees who have phones and the rest of the rows would be hidden. And if we check the filter for blanks we will only see employees who do NOT have phones and the rest of the rows would be hidden. How cool is that?
To reset the filter, we can choose Select All and all rows would be shown.
I invite you to try this out and see what you think! Put this one in your bag of Excel tricks and you really can impress your boss or colleagues with your ability to quickly filter for certain rows in your spreadsheet. Leave a comment and let me know how it goes and any additional filtering tricks you find!