Sorting Problem

[hedonman]

Hello MrExcel Members,

I've tried doing a search with no ado, so I am here to ask help for my problem.

I am trying to sort a worksheet with 4 columns. I want sort one column alphabetically but still maintain the rows connecting to the sorted list.

like this:

B 55 CAN cat
A 15 US stuff
C 44 ITA dog
E 11 ME fan

to this:
A 15 US stuff
B 55 CAN cat
C 44 ITA dog
E 11 ME fan

I'm thinking i have to use some sort of grouping? Please enlighten me.

 

[sous2817]

Hello and welcome to the board!

Select the entire area you want sorted, not just the column you want sorted alphabetically.

 

[Desu Nota from Columbus]

select (highlight) the entire area you want sorted, then sort the data based on column 1. All the attached info by row will change accordingly.

For Excel 2003,

Once data is highlighted, select Data --> Sort