Maybe you have filtered by multiple columns.

Try:
Data|Filter|Show All
(instead of using the dropdown arrow in each column and selecting (All).)

Or maybe those rows were hidden manually???????

wrote:

Sorry but sometimes I don't understand if it is me or Excel....?!
I have set the usual Automatic Data Filter and now I have those
beautiful select at the top of the page.
I select a filter and naturally Excel collapse rows so to show only my
desired values.
THEN...I select show all in the select form of the same column and I
again have all the rows...BUT at the end of the data (imagine I have 60
rows of data) so from 61 to 70 (and I don't understand why 70!) rows
are collapsed. And not hided but collapsed...I have to take one by one
with my mouse and enlarge the. Of course if I go to the main menu,
data, show all they appear again. From 71 everything is fine.
I don't understand why...!?!?
Am I missing something? Where is the trick? Do I need some holidays?
Thank you.
Ataru

--

Dave Peterson