Using the Sort Command in Excel

Step by Step Instructions on Managing Data in a File

© James Hutchinson

A simple guide to using the Data Sort commands and icon in Microsoft Excel.

Microsoft Excel has many helpful commands that can be used to manage large files. Microsoft Access is specifically designed to handle large databases, but Excel can be a simpler option for data that needs to be manipulated for reporting purposes.

Sorting of data is easy, but there are steps that need to be followed to make sure that the data remains correct, and tricks to make collating the data fast and accurate.

Sorting using the Data Sort Command

In order to use the sort command, Excel needs at least 2 rows of data in at least 1 column. The best use of the command is for many rows of data, where manually sorting is difficult.

Excel will make a determination of what data should be sorted based on where the cursor is. Make sure that all columns are included in the sorting area before beginning the sorting process. If there is a question on what data should be sorted, highlight the appropriate rows and columns.

Follow these steps:

  1. From the toolbar, select Data, and then Sort.
  2. A box pops up, offering up to three sorting options.
  3. Choose the first option (“sort by”) and select the column that you want to sort by, and whether the sort should be ascending or descending. Excel will default to the column where the cursor is located and ascending order. Using ascending will sort from A to Z and from 1 to 10, and descending will sort the opposite (Z to A and 10 to 1.) If the column includes both letters and numbers, in ascending mode, numbers will precede letters. Blank spaces will follow letters.
  4. The final selection in the box is whether the data has a header row, or title. Titles would normally be excluded from the sort, and Excel will make an assumption on whether the first line is a header row. Change the selection as needed.
  5. Clicking “OK” will execute the sort.
  6. Review the results. If there is a concern that the sort was performed improperly, click “Back” icon and start again. Re-sorting from a bad result will corrupt the original data, and make it impossible to assure that the data in the rows match correctly.

An Example of Multiple Sorting

Using Data Sort provides the ability to sort the data on 3 different columns in one action. For example, a spreadsheet could have 3 columns for football players, one each for name, team and position.

Data Sort can arrange the order by team, then position and finally by name in alphabetical order by selecting the columns in that order in the sort box.

Sorting Using the Sort Icon

The 2 sort icons have AZ or ZA with an arrow next to them, and are located on the standard toolbar. The buttons have the same function as Data Sort. They execute the sort faster, but are more limited in what they can do.

Things to be careful about when using the sort icon:

Data Sort is a valuable Excel command, allowing the user to manage large files easily, and get the most out of this Microsoft Office tool.


The copyright of the article Using the Sort Command in Excel in Office/Business Software is owned by James Hutchinson. Permission to republish Using the Sort Command in Excel must be granted by the author in writing.




Post this Article to facebook Add this Article to del.icio.us! Digg this Article furl this Article Add this Article to Reddit Add this Article to Technorati Add this Article to Newsvine Add this Article to Windows Live Add this Article to Yahoo Add this Article to StumbleUpon Add this Article to BlinkLists Add this Article to Spurl Add this Article to Google Add this Article to Ask Add this Article to Squidoo