This Excel tip shows you how to Sort Data Alphabetically and Numerically in Excel 2007. This is a great feature to use when analyzing and organizing large sets of data and it can help to make sense out of all of that data.
The sort feature in Excel allows you to very quickly sort any data set alphabetically and also numerically. That means A-Z, Z-A, 1-10, and 10-1. Basically, this is sorting data forwards and backwards.
Steps to Sort Data Alphabetically or Numerically in Excel 2007:
Note: You may or may not have headers for your data. Excel doesn't care if you have headers but it will try to determine on its own whether or not your data does contain headers. Also, this method is a very quick way to sort your data alphabetically or numerically. If you need to you can perform more advanced sorting methods in Excel by clicking the button to the right of the two small sort buttons in the ribbon menu.
Location of Sort on the Excel 2007 Ribbon Menu:
Excel Worksheet Before Sort:
Excel Worksheet Before Sort: