Excel will not do the filter on all rows

Closed
Puja - 9 Jun 2010 à 11:33
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 Jun 2010 à 11:35
Hello,

I'm trying to sort and filter a file with 167 rows. When I do the filter, it will only go up to row 150. I looks like it will not do anything below a certain row. How do I fix this?
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
9 Jun 2010 à 11:35
Chances are there is a blank row at that spot. So try one of the following
A. Delete Blank row
b. Before applying the filter select all cells