Hello,
I think that in the past, I've seen Excel spreadsheets with header rows
that have little directional sorting arrows in them. So, by clicking
on the icon of any column, the data is sorted by the values in that
column.
I realize that this can be done by going to 'Sort' under data, and
picking the column, but I'd love to be able to click directly in the
header.
Is there a way to do this?
Thanks,
Ben
Dave Peterson - 25 Oct 2006 02:48 GMT
xl2003 added an option to sort under the arrows that you get when you apply
Data|Filter|Autofilter. Could that be what you saw?
You can use another technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html
> Hello,
>
[quoted text clipped - 11 lines]
> Thanks,
> Ben

Signature
Dave Peterson