I know exactly what you're talking about.
First, here's what you did:
1. Identified the column you wanted to sort
2. Clicked the column header (the letter representing the column: "A", "E", etc., you'll see the entire column get highlighted)
3. Clicked the sort button
When you do this, Excel thinks you want to sort just that column's data while leaving the other surrounding data intact.
Now, here's what you wanted to do:
1. Identify the column by which you want to sort
2. Simply click the first cell in that column (only one cell will be selected, ie. have a border around it)
3. Click the sort button.
All data in your table will sort according to that column.
Another approach is to go to the "Data" menu and click "Sort...". Select which columns you want to sort and by what order.
Cheers.
__________________
be the change you want
|