To do this, follow these steps:
- Click the row number that you'd like to hide at the bottom of your worksheet.
Make sure the whole row is selected, by clicking within the grey-margin.
- To select all rows below, press CTRL+Shift+Down arrow.
- Right click within all the highlighted rows and select hide.