Did you know that you can sort data from Left to Right in Excel? In my experience, most people do not realize that you can.

Have you ever been asked  – or wanted – to rearrange your columns in Excel? Probably, yes. This is a fairly common request. And, if you are like most Excel users, you insert a blank column and then “Cut and Paste” to arrange your columns the way that you want them.

STOP!

There is an easier way to rearrange your columns of data – Learn to “Sort Across Columns.” Sort your data from Left to Right.

Watch this short Excel Video Lesson to learn how:

Here are the steps to follow in this lesson:

1. Insert a blank “dummy row” above your Column Headers Row (if necessary).
2. Place a number (1, 2, 3, etc.) in each cell in the “dummy row.” This will indicate the order you want to rearrange your columns in from Left to Right.
3. Select a cell in your data set. Select Data – Sort.
4. Check, “MY Data Range has NO Headers.”
5. Click, OPTIONS and select “Sort from Left to Right.” Click OK and Click OK.

Looking for help with a specific Excel problem? Search my Index of Excel Video Lessons by Category or by Keyword.

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons

• Sort Data Using a Custom List

NEW! Download The Excel Workbook used in this video lesson:

rearrange-columns