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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 the
pick the columns you want to sort by
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting columns sorts header values too 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Sort table with one click on header? 9
Sorting columns with locked headers in Excel 07 1
Sort confusion 2
Rename imported MS Access field names 1
stop sorting titles please 3
Column headers affected by sort function 1

Back
Top