How does Excel 2002 sort a worksheet when you use the sort tool? I want to
quickly sort a spreadsheet by one column, for example to see how many people
fit into a particular category, so i click on the top cell of the column and
click the sort (A-Z) tool. But not all columns sort with the sorted column,
so my data get scrambled. How do I avoid this? Sometimes it seems to work
correctly and other times it doesn't. I don't understand why.