Tuesday, May 22, 2012

How to Sort a Row or Column in 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.

Blogger news