Sorting Entire Columns

**jlkirk** · 05-24-2011, 12:07 PM

I have approximately 100 columns of data in rows 2-1500. I would like to sort these columns by the name of the column in reow 1. Any help?
Thanks in Advance.

**Blake 7** · 05-24-2011, 12:12 PM

Home tab of ribbon > sort and filter > custom sort

**jlkirk** · 05-24-2011, 12:21 PM

Thanks Blake. Unfortunately I don't see a custom sort being available. It just allows me to sort by individual rows.

**Blake 7** · 05-24-2011, 12:29 PM

Hiya - on the extreme right of the ribbon (XL 2007) click sort and filter and a drop down menu will appear starting with sort A/z then Z/A then CUSTOM SORT > select custom sort then sort by column.

**jlkirk** · 05-24-2011, 12:36 PM

Sorry-I get the same options under that tab as I do under the normal Data/Sort tab...only by individual rows

**Blake 7** · 05-24-2011, 12:48 PM

have you seen the add level button?

**jlkirk** · 05-24-2011, 01:07 PM

Yes I see that, but it only offers individual rows

**Blake 7** · 05-25-2011, 05:13 AM

Hiya - sorry to take so long to respond. I'm sure that we can get to the bottom of this! why don't you upload a sample of your dataset and describe or give a before and after shot of what you want.