Home »  Software »  Office Suite Software

How Do I Sort a Row or Column in Microsoft® Excel®

January 10, 2012  |  Difficulty: Easy

how to sort data in your Microsoft® Excel® 2010 spreadsheet or table

The Microsoft® Excel® 2010 spreadsheet offers many functions for organizing data and information contained in your documents. Many people use this Microsoft Office® application for making lists, counting, and creating overview tables. There are sorting functions for columns and rows to help you accomplish the desired result. To learn how to sort data in your Microsoft® Excel® 2010 spreadsheet or table, read below.


  1. Start the Microsoft® Excel® 2010 application.
  2. Open the file in which you want to sort a row or column, or create a new one.
  3. Mark the column(s) or row(s) you want to sort.
  4. Open the Data menu and select “Sort”. The Sort dialog box will appear.
  5. In the “Column” dropdown menu, choose a column you want to sort.
  6. In the “Sort On” dropdown menu, choose the main sorting factor.
  7. In the “Order” dropdown menu, choose the sorting order.
  8. Click the “OK” button.

Tips and Tricks:

  • You can add a secondary filter for sorting the columns or rows selection by clicking on the “Add level” button in the sort window to set the additional sorting.
  • You can sort numbers and alphabetic characters as well.


Most Popular Articles:

What Is the Best Backup Software for Me

Internet Security Solutions Detect Legitimate Soft

How Do I Block Internet Intruders from Spying

How Do I Choose a Data Backup Software

How Do I Install a FREE Spyware and Adware Blocker

Related Articles:

How to share a workbook in Microsoft® Excel 2010 so other people will see the changes

How Do I Share a Workbook in Microsoft® Excel 2010

How to insert a new line, row, or column between ones that already exist

How Do I Add a Line or Column in Microsoft Excel®

how to insert a chart into a Microsoft® Excel® 2010 spreadsheet

How Do I Make a Chart in Microsoft® Excel® 2010

how to download and install OpenOffice© free office suite.

How Do I Install OpenOffice©

How to format and merge cells in your Microsoft Excel® spreadsheet

How Do I Merge Cells in Microsoft Excel®

Help Us Spread the Word!

Love us on Facebook to stay updated.

Stay aware and get our best content on health, celebrity, travel, living, career and the technologies that will change the world.