Hide rows automatically

Hi I have a worksheet for kids in class it is 10 columns and 20 rows.
Is there a way to prevent the display of all the other rows quickly without
selecting and hiding?
Thanks

Maybe you could select your range and apply Data|filter|autofilter.

You can use those arrow dropdowns to show what you want to show.

kim wrote:
>
> Hi I have a worksheet for kids in class it is 10 columns and 20 rows.
> Is there a way to prevent the display of all the other rows quickly without
> selecting and hiding?
> Thanks

--

Dave Peterson