Tip Printed from ExcelTip.com

---

Sorting by Columns


The default setting for sorting in Ascending or Descending order is by row.
To sort by columns:

1. From the Data menu, select Sort, and then Options.
2. Select the Sort left to right option button and click OK.
3. In the Sort by option of the Sort dialog box, select the row number by which the columns will be sorted and click OK.