Sort Arrows in Header Row

[bwilde]

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]

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