View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Colby Colby is offline
external usenet poster
 
Posts: 10
Default Sort table with one click on header?

Hi Gord,

Thanks for the quick response. I was hoping there was a way to set it up so
users could just click on the column heading *without* having to go to
DataSort. The Create List pull-down would be OK if I could eliminate the
other filter options that appear there. [The fewer options there are for my
users, the better :-) ]

Colby

"Gord Dibben" wrote:

Colby

If you have created a List select top cell in a column(not the column header)
and DataSort

Or don't create a list and just click on a header and DataSort.


Gord Dibben MS Excel MVP


On Sat, 3 Mar 2007 15:31:05 -0800, Colby
wrote:

I want to sort a table in Excel 2003 by clicking on any of the column headers
-- like in an email window. The "Create List" feature is almost what I need,
but I want to show only "Sort Ascending" and "Sort Descending" on the
pull-downs. [It's unfortunate that you have to scroll *up* to see the Sort
options in those pull-downs.]

Is there a way to eliminate or mask the other filtering options that appear
in the List pull-downs? Or is there another way I can sort by column headers
with one click?

Thanks for any ideas on this.