How to Sort a Row or Column in Excel

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:

• Excel Book
• Microsoft Excel

1. Start Microsoft Excel and open the file you want to change.
2. Drag over the two or more columns or rows that you want to sort.
3. Open the Data menu and select Sort. The Sort dialog box appears.
4. Select the Continue with the Current Selection option to sort a single column or row.
5. Select the Expand the Selection option to sort a series of columns or rows.
6. Choose Ascending or Descending to determine the sort order.
7. Click the Options button in the Sort dialog box.
8. Select "Sort top to bottom" in the Sort Options dialog box to sort a column.
9. Select "Sort left to right" in the Sort Options dialog box to sort a row.
10. Click OK in the Sort Options dialog box.
11. Click OK in the Sort dialog box.

Tips & Warnings

• You can sort numbers and alphabetic characters.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.