LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Sort table with one click on header?

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
get sort to recognize header row widman Excel Discussion (Misc queries) 3 October 25th 06 04:14 AM
sort, 2 row header Kath Excel Worksheet Functions 5 April 14th 06 11:19 PM
how can I sort with header not on row 1 tryer Excel Discussion (Misc queries) 4 March 31st 06 09:28 PM
SORT Header Row(s) Karen Excel Discussion (Misc queries) 1 January 4th 06 01:33 AM
Click on graph bar to execute a double-click in a pivot table cell [email protected] Charts and Charting in Excel 4 August 3rd 05 01:37 AM


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"