Hide rows automatically

K

kim

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
 
D

Dave Peterson

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

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