How to Sort Columns by Clicking on Column Header

Hello All,

I am working on an excel spreadsheet for my office and am trying to figure out how to add a sorting function.
Essentially, I will have several columns titled "Country" "Region" "Name of Director" "Donor" etc. To facilitate navigating the spreadsheet, I want to add some sort of button to each Column Header that, when you click it, it automatically sorts the data based on "region" or "director" etc.

...Pretty much exactly the way that itunes columns work: you click "Song" and it organizes the spreadsheet alphabetically by song. Same thing for album and genre. Mine will be very similar because all the sorting can be done alphabetically. I just want to be able to click on the column head rather than having to go to the "A-Z autofilter" button each time.

Any help would be greatly appreciated!

Thanks so much,

HW

Hi..

Heres one way..

Basically.. just double click in the column header cell to sort..

Adjust ranges to suit.. see attachment for example..

Please Login or Register  to view this content.