Excel will not do the filter on all rows

Closed
Puja - Jun 9, 2010 at 11:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 11:35 AM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 9, 2010 at 11:35 AM
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
0