EXCEL -Sorting a Column Alphbeticially 2

[jhetfield]

I'd like to sort an excel worksheet by a specific column. I tried highlighting the column & then clicking the sort alpha. button but it sorts the column but doesn't keep the other column's info. tied to the sorted columns info.

thanks, Jason

 

[Bowers74]

1. Select all of the cells in the table (optional).
2. Goto Data->Sort...
3. Select the column(s) that you want to sort by in the order you want to sort by.
4. Don't forget to check or uncheck "Header Row" (if you have a header row, then check it, if not uncheck it).
5. Press OK


Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[KenWright]

Hi Mike - Your step 1 is only optional in some versions of Excel. In later ones it will recognise that there is data to the right or left of your data and ask you if you want it included in the sort. In earlier ones it will simply ignore any data outside your selected range and only sort the selected area, and hence I think the OP's problem. Probably safer to leave the 'optional' bit off your note and then you have all bases covered.

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------