If you're using xl2003, you can use the dropdown arrow from data|filter to
choose to sort. But it's not automatic.

You may want to try this method from Debra Dalgleish's site:
http://contextures.com/xlSort02.html

Tsunami3169 wrote:

Hello everyone, I'm setting up a metrics spreadsheet with many columns.
The spreadsheet has business data for 2006 and 2005. Also the variance
between the two. To make life easier for Senior Management I need to
provide a way for them to sort the data with minimal steps. Any
suggestions? The spreadsheet only has 48 columns and they need the
ability to sort on any of these columns.

Thanks for any help and suggestions in advance.

--

Dave Peterson