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.

Notes

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.


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 situati...
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....
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...
Copy and Paste Data using Macro VBA in Excel
Tutorial: How to copy and paste data using a Macro in Excel. I'll show you multiple ways to do this,...