How To

How to Sort a Row or Column in Excel 2003

Contributor
By eHow Contributing Writer
(6 Ratings)

Excel is one of the most widely used programs on home and office computers. Even so, improvements are being made for each new edition. Follow the steps below to sort a row or column in Excel 2003:

Difficulty: Moderately Easy
Instructions

Things You'll Need:

  • Computer
  • Excel 2003
  1. Step 1

    Open your Excel worksheet after logging on to your computer. You should be able to locate the program by using your “Start” button. When you cannot find it there, use your “Search” or “Find” function.

  2. Step 2

    Click on any cell within the range of cells you would like to sort. Go to “Data”. Select “Sort” from the appearing menu.

  3. Step 3

    Choose “Options”.

  4. Step 4

    Select “Sort Left to Right” from the displayed “Orientation” menu. Choose “OK”.

  5. Step 5

    Select the rows to sort from the “Sort By” and “Then By” boxes. Sort one column without affecting others by clicking the column heading of the column to sort.

  6. Step 6

    Choose “Sort Ascending” or “Sort Descending”. A “Sort Warning” will be displayed.

  7. Step 7

    Select “Continue with the Current Selection”. Then click “Sort”.

Tips & Warnings
  • Select “Undo” from the "Edit” pull-down menu, if results differ from what was expected.
  • Exclude a column header by selecting “Sort” from the "Data” menu. Then choose “Header Row” from the “my data range has” heading.

Post a Comment

Post a Comment

Have you done this? Click here to let us know.

I Did This

Related Ads

Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow’s Computers Expert.

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.

eHow Computers
eHow_eHow Technology and Electronics