eHow launches Android app: Get the best of eHow on the go.

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.
Subscribe

Post a Comment

Post a Comment

Related Ads

  • Have you done this? Click here to let us know.
I Did This
Tags
Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy .   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License. † requires javascript

eHow Computers
eHow_eHow Technology and Electronics