How to automatically sort the columns (move the columns around)

I have Excel 2010. I'm not an expert.

I frequently receive a 40-column spreadsheet. I know how to move the columns manually. I'm wondering if it's possible to move columns automatically.

Here's a simple 3-column example. I receive a spreadsheet with the headings H1, H2, and H3, from left to right.

How can I move the columns so that the columns are H2, H3, H1 from left to right.

Hi,

The simplest thing that I could suggest would be to keep a template worksheet with formulas setup to rearrange the columns, e.g. in cell A1 on the template sheet, enter the formula

Formula:

Please Login or Register  to view this content.

and copy this formula down the column as far as is necessary to move column 3 to column 1, then similarly for the other columns. Then each time you receive a new spreadsheet, paste the data into the template workbook on a different worksheet called "Data". Then your template worksheet should display the columns in the order that you desire.

I hope this helps

Originally Posted by ajryan88

Hi,

The simplest thing that I could suggest would be to keep a template worksheet with formulas setup to rearrange the columns, e.g. in cell A1 on the template sheet, enter the formula

Formula:

Please Login or Register  to view this content.

and copy this formula down the column as far as is necessary to move column 3 to column 1, then similarly for the other columns. Then each time you receive a new spreadsheet, paste the data into the template workbook on a different worksheet called "Data". Then your template worksheet should display the columns in the order that you desire.

I hope this helps

Hi ajryan88,

Thanks for your fast response. That works great

You're welcome!

Please don't forget to mark this thread as solved and click on the * next to my post to say thanks!