Under the Data menu you wil find the "Group and Outline" command.  To use it,
select the rows you want to be able to hide, then click into this menu and
select the Group option.

You can do the same with columns, BTW