Filter not showing all results

Hi,

I have a very large spreadsheet (almost 9000 rows). I have filters on all columns, however when I click to see all the results for the column under the filter, just to view the contents of the row, some are not there.

Does a filter have a limitted amount of rows it can hold.

Apologies if I have not described this very well. Please ask if you need further clarification.

Thanks

yep the view is only 1000 different cells , but will all filter correctly
use custom and put value in there