pl456 Registered User. Local time Today, 18:53 Joined Jan 31, 2008 Messages 150 Dec 4, 2009 #1 Is it possible to sort columns horizontally? i.e. you have 6 columns with 1,2,3,4,5 & 6 as a header number but they are not in sequential order.
Is it possible to sort columns horizontally? i.e. you have 6 columns with 1,2,3,4,5 & 6 as a header number but they are not in sequential order.
Brianwarnock Retired Local time Today, 18:53 Joined Jun 2, 2003 Messages 12,667 Dec 4, 2009 #2 Click Data Sort and then options, there is a sort left to right option. Don't forget to select the whole area. Brian
Click Data Sort and then options, there is a sort left to right option. Don't forget to select the whole area. Brian
pl456 Registered User. Local time Today, 18:53 Joined Jan 31, 2008 Messages 150 Dec 4, 2009 #3 Spot on cheers.
Brianwarnock Retired Local time Today, 18:53 Joined Jun 2, 2003 Messages 12,667 Dec 4, 2009 #4 Happy to help, especially as I didn't know till I looked, so I learnt something too. Brian