Sort Data Left to Right in Excel

Add to Favorites

How to sort columns of data in Excel.  This is the same as sorting left to right.

This will change the position of entire columns of data quickly and easily.

Steps to Sort Data Left to Right in Excel

  1. Select the data that you want to sort or select a cell within that data.
  2. Go to the Data tab and click the big Sort button and NOT one of the smaller ones.
  3. In the window that opens click the Options... button.
  4. In the next window that opens, select the option Sort left to right and then hit OK.
  5. In the first window, we now need to setup the sorting.
    Under where it says Row, click the drop down menu and select the row by which we want to sort.  In this case, we are sorting by Row 1.
  6. Move to the next drop down menu and select Values, or another option if that better suits your needs.
  7. Move to the last drop down menu and select how to sort the data.  In this case, we will leave it at A to Z.  Then, hit the OK button.
  8. That's it!

If you made a mistake, you can always hit Ctrl + Z to undo the sorting and start over.


If you don't select "Sort left to right" after clicking the Options button, a regular up and down sort will be performed.

Don't forget to download the accompanying sample file so you can try this out.

Question? Ask it in our Excel Forum

Downloadable Files: Excel File

Similar Content on TeachExcel
Sort Data Alphabetically or Numerically in Excel 2007 and Later
Tutorial: This Excel tip shows you how to Sort Data Alphabetically and Numerically in Excel 2007. T...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
Use a Form to Enter Data into a Table in Excel
Tutorial: You can enter data into a table in Excel using a form; here I'll show you how to do that....
Get Data from Separate Workbooks in Excel
Tutorial: How to get data from separate workbooks in Excel. This tutorial includes an example using ...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...