When you go to sort a column, you might get a warning that reads "Microsoft Office Excel found data next to your selection. Since you have not selected this data, it will not be sorted. What do you want to do?" the options are "Expand the selection" and "continue with the current selection." If you hit "expand the selection," it will sort all data by the heading that you chose. If you continue with the current selection, it will just sort that column.
The other way to do that is to just select the entire group of data, and hit the Sort Button, and then choose what column you want to sort by.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
no subject
Date: 2010-04-05 03:28 pm (UTC)The other way to do that is to just select the entire group of data, and hit the Sort Button, and then choose what column you want to sort by.
That should keep everything aligned.