question about sorting
Hi folks, I am back again with another question for the excel gurus. I have attached a spreadsheet with 3 columns, its a song playlist and there is title, author, and comments in the 3 columns. As you can see, at the moment the songs are not sorted in alphabetical order. I want to sort these songs 2 ways, alphabetically by title, and alphabetically by author, and I want to sort them both ascending and descending. I know I can do this manually using the sort button, select column A or B and sort ascending or descending. That all works, but I want to be able to sort the entire songlist alphabetically, by just left clicking once on title or author, and them having excel sort my song list alphabetically a to z or z to a, based on whether I select title or author. I have seen many databases where this is done and there is an up/down arrow one selects to sort either ascending or descending, but I dont know how its done. Do I need to use a macro rather than formula(s)? Any suggestions? Many thanks
|