I saw this thread, http://www.excelforum.com/showthread...ght=sort+state but it doesn't seem to work for me.

I have a huge spreadsheet, listed alphabetically by first name. I'd like to sort by state.

I click on the entire spreadsheet (button to the left of column A) and sort, selecting the header titled "state". It sorts but it's not keeping rows together.

example:
Row #4: Alan X, Encino, CA.

when sorted:
George Y, Encino, CA

Help?