Sorting Problem

[rwmill9716]

I have an Excel sheet that uses 84 rows and columns A to AT. My table heading with filter is in row 3. My problem is that when I try to sort any of the columns, it only sorts through row 80. The last four rows remain unsorted. There are no hidden rows, and the column data is all in the same numeric format. Even when I remove the row data where the sort break had occurred (row 81), it still only sorts to row 80. If I highlight the data and use the sort function, it works fine; it's the filter that has the problem.

 

[rwmill9716]

I found the answer: the sorting filter is tied to the limits of the conditional formatting. I was conditional formatting to row 80; hence I couldn't use the filter sort to the 84 row limit. When I changed the conditional formatting limit, the filter sort worked fine.