How to Sort a Row or Column in Excel

By eHow Computers Editor

Rate: (13 Ratings)

Excel makes it easy to sort a range of values. You might not think of sorting spreadsheet values, but it can come in handy; sorting can help alphabetize a column of row names, for example. These steps are intended for Microsoft's Excel 97.

Instructions

Difficulty: Moderate

Things You’ll Need:

Step1
Start Microsoft Excel and open the file you want to change.
Step2
Drag over the two or more columns or rows that you want to sort.
Step3
Open the Data menu and select Sort. The Sort dialog box appears.
Step4
Select the Continue with the Current Selection option to sort a single column or row.
Step5
Select the Expand the Selection option to sort a series of columns or rows.
Step6
Choose Ascending or Descending to determine the sort order.
Step7
Click the Options button in the Sort dialog box.
Step8
Select "Sort top to bottom" in the Sort Options dialog box to sort a column.
Step9
Select "Sort left to right" in the Sort Options dialog box to sort a row.
Step10
Click OK in the Sort Options dialog box.
Step11
Click OK in the Sort dialog box.

Tips & Warnings

  • You can sort numbers and alphabetic characters.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Sort a Row or Column in Excel

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads