The default setting for sorting in ascending or descending order is by row. Occasionally, you may want to sort by column instead. To do so, choose Data, Sort, then click the Options button. Choose Left to Right, then click OK. Select the row that you want to sort by, then click OK.