Fixing Sort Problems
If it looks like the data did not sort properly, refer to the following list of possible solutions:
- Make sure no hidden rows or columns exist.
- Use a single row for headers. If you need a multiline header, either wrap the text in the cell or use Alt+Enter to force line breaks in the cell.
- If the headers were sorted into the data, there was probably at least one column without a header.
- Column data should be of the same type. This may not be obvious in a column of ZIP codes where some (such as 57057) are numbers, but others that start with zero are actually text. To solve this problem, convert the entire column to text.
- If you’re sorting by a column containing a formula, Excel will recalculate the column after the sort. If the values change after the recalculation, such as with RAND, it may appear that the sort did not work properly, but it did.