how can i eliminate blank rows that exist beyond the last non-bank row?

[joe miller]

[h=2]my spreadsheet has more than a million blank rows after the last non-blank row.
how can i eliminate those blank rows?[/h]

 

[sheetspread]

Click on the first blank, ctrl-shift-down arrow, delete the rows'' didn't work
but Click on the first blank, ctrl-shift-down arrow, hide the rows'' did work.

Glad it works. When you said eliminate, my first thought was to prevent the scroll bar at the right from moving beyond the nonblank worksheet section. That happens if you adjust an entire column (e.g. by copying/pasting if I recall). Deleting is one solution, but you can't actually remove the blank rows.

 

[joe miller]

-