Excel Basics: How to Sort and Filter Data in Excel

Put a list in order by one or more columns, and show only the rows you need with text and number filters. ✓ Sort a list A to Z or largest to smallest without breaking its rows ✓ Sort by two columns with the Sort dialog ✓ Filter a list to show one category ✓ Show only rows above or below a number with Number Filters ✓ Clear a filter and get all your rows back