Sorting data in a table by the header of a column?
 

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?

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

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?