Here is a real easy way to do what you are talking about.
You can use a Data Filter to select the rows you want. Just create a new column, which has the row number as it's value. I typically call the new column "TheRow". Use
Row()
as the formula for the column
Now just go to
Rows=>Data Filter
and choose column "TheRow" as what to filter on.
You can either enter in absolute values as seen above, or interactively move the lower and upper boundaries to the values you want
Jim