Excel columns

MaryLass · Mar 27th, 2002, 09:51 AM

How do you switch the order of columns?Example: you have columns:
March 1 March 2 March 3 March 4
You now want to switch the order to:
March 4 March 3 March 2 March 1
Do you have to manually cut and paste or is there a quicker way?

Damon Ostrander · Mar 27th, 2002, 10:20 AM

Hi MaryLass,

If this is what you actually want to do (not just a hypothetical example) it can easily be accomplished via a sort. You simply need to sort right-to-left rather than vertically. To do this, first select all the data (rows) you want sorted, then use the Data -> Sort rather than the toolbar sort button. Select Options to select right-to-left. Use a descending sort on the first row and voila!

MaryLass · Mar 27th, 2002, 10:34 AM

To Damon: THANKS FOR YOUR QUICK REPLY

Chris Davison · Mar 28th, 2002, 01:02 PM

Damon,

you have *got* to be kidding me....

Like an idiot, I assumed that the sort worked vertically only, as with filter. Now I know better !

Having split one of my molars in half lastnight and spending all morning at the dentist's ON the last day of our financial year, this little gem has just made my day.

Even better than the fact his background music was the Queen of the Night aria from Mozart's "Die Zauberflaute".

Mar 27th, 2002, 10:20 AM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi MaryLass, If this is what you actually want to do (not just a hypothetical example) it can easily be accomplished via a sort. You simply need to sort right-to-left rather than vertically. To do this, first select all the data (rows) you want sorted, then use the Data -> Sort rather than the toolbar sort button. Select Options to select right-to-left. Use a descending sort on the first row and voila! __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 09:51 AM	#1
MaryLass New Member Join Date: Mar 2002 Posts: 2	How do you switch the order of columns?Example: you have columns: March 1 March 2 March 3 March 4 You now want to switch the order to: March 4 March 3 March 2 March 1 Do you have to manually cut and paste or is there a quicker way?

Mar 27th, 2002, 10:34 AM	#3
MaryLass New Member Join Date: Mar 2002 Posts: 2	To Damon: THANKS FOR YOUR QUICK REPLY

Mar 28th, 2002, 01:02 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Damon, you have got to be kidding me.... Like an idiot, I assumed that the sort worked vertically only, as with filter. Now I know better ! Having split one of my molars in half lastnight and spending all morning at the dentist's ON the last day of our financial year, this little gem has just made my day. Even better than the fact his background music was the Queen of the Night aria from Mozart's "Die Zauberflaute".