Excel Tip: Sorting From Left to Right

You probably already know how to sort a vertical list in Excel (and here's a refresher if you don't), but what can you do if you want to put your column headings in alphabetical or chronological order? Can you sort your data from left to right?

Sort Top to Bottom

To quickly sort a column of data from top to bottom, you can click anywhere in the column and then click the A-Z button on the standard toolbar (or click Z-A if you want to sort backwards). The column will be sorted in alphabetical or chronological order.

All occupied cells adjacent to the sorted column will be sorted along with the column in which you clicked. To make sure all the proper cells get included in the sort, you can select the cells to be sorted before performing the sort task, making sure your active cell is in the column by which you want to sort (Hint: After selecting the block of cells, press the Tab key until your active cell moves over to the column by which you want to sort.).

For a more detailed top/bottom sort, click in any cell in the data (all data to be sorted should be in adjacent cells and not separated by any blanks), then choose Data, Sort from the menu. In the window that appears, choose the first column by which you want to sort, and pick from Ascending and Descending, then choose the second column, and if you like, a third column. The sort will be performed in the order you indicate.

Sort Left to Right

To sort data across the columns instead of up and down the rows, you can follow these steps:

1. Click anywhere in the data to be sorted. Select the data first if there is any ambiguity in terms of which cells should be sorted.

2. Choose Data, Sort from the menu. The Sort window will appear.

3. Click the Options button and choose the Sort left to right option. Then Click OK.

4. Choose the row (or rows) by which you want the sort to be performed, and indicate if the sort is to be in Ascending or Descending order.

5. Click OK to execute the sideways sort.

View more helpful tips!

You may like these other stories...

Earlier this week I presented the Chart Edition of AccountingWEB’s High Impact Excel webinar series. One of the many topics I covered was the Sparklines feature, which was first introduced in Excel 2010. Several...
On January 30, I led a free, one-hour webinar, High Impact Excel: Pivot Table Edition. If you missed the presentation, it’s too late to get CPE credit, but you can watch an on-demand recording. After the webinar, I...
By David Ringstrom, CPA In Part 1 of this series I showed how to use a custom number format to conditionally display decimal places. Although the technique is simple, the downside is it may not work in every situation....

Already a member? log in here.

Upcoming CPE Webinars

Sep 24
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
Sep 30
This webcast will include discussions of important issues in SSARS No. 19 and the current status of proposed changes by the Accounting and Review Services Committee in these statements.
Oct 21
Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience's communication style.
Oct 23
Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.