Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a way to get excel to sort the data in a table by clicking on the
header of a column like a windows folder does? |
#2
![]() |
|||
|
|||
![]() No. You have to go to data/sort..tell it you have a header, and then pick the columns you want to sort by. -- dfeld71 ------------------------------------------------------------------------ dfeld71's Profile: http://www.excelforum.com/member.php...o&userid=21452 View this thread: http://www.excelforum.com/showthread...hreadid=374497 |
#3
![]() |
|||
|
|||
![]()
Hello Aaron,
Not from the column labels A, B, etc. but from within the column of data that should be the primary sort, you can sort ascending or descinding order by clicking the A-Z or Z-A sort icons in the standard toolbar. You can perform more advanced sorting by choosing Data, Sort from the menu (from within your table of data.) Does this help? Cheers, Annie "Aaron" wrote: Is there a way to get excel to sort the data in a table by clicking on the header of a column like a windows folder does? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Problems with sorting a pivot table | Excel Discussion (Misc queries) | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |