Change number of rows that are displayed

I have read in other threads that there should be a settings option on the spreadsheet when signed in as administrator, and that I should be able to adjust the number of rows in the settings. However, I don’t see a settings option. Is there another way to change the number of rows displayed? Currently there are 50 and I only need 18. Thanks.

Hi,
don’t you see the Settings button because sreadsheet’s width is little or because you don’t have edit rights (you don’t see color/bold/italic/align options in spreadsheet’s header in this case)?
If it’s the first case then you may set bigger width value, set number of rows and restore width value.
For the second case it would be the best way to get edit rights.