I have a softball spreadsheet with columns of ab, r, h, 2b, 3b, hr, bb, so, Avg. rows of all the players on the team.

I'd like to be able to click on the cell containing any cloumn heading and have the data sort out from best ot worst of that catagory.

Is it possible to re-sort data simply by clicking on a certain cell, and if so can it be done for 8 different cells?

Thank you all for your help!