Hi

Click on any cell in your table
Insert tabTableOK
Choose dropdown on StateSort
--
Regards

Roger Govier


"HHoosier" wrote in message
...
1) FWIW I have excell 2007
2) I highlight all cells, go to sort, custom sort, sort by state
column =
states sort alphabetically, nothing else sorts.

I am doing something wrong.

"Ron Coderre" wrote:

Try this:

Select the entire range of data, including the column headings
(State,
Customer, etc)
From the Excel main menu: <Data<Sort
First "Sort By" dropdown should list the column headings
(If it doesn't, Check: My list has: Header Row)

Select: State from the list
Check: Ascending (or descending)
Click the [OK] button

The list will sort by state and all corresponding data for each row
will
move accordingly.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"HHoosier" wrote:

I need to sort a rather large data base. Coulmns are State,
Customer,
Product, Product Size etc. The entries currently are in order of
invoice.

I need to start by sorting by state, keeping all information
together
(State, customer ,product, product size etc.) just as it appeared
in
origional data base but now sorted by State vs Invoice.

Thanks in advance