Removing blank rows

[Bagwash]

Can someone kindly remind me how to remove the blank rows that show below
the data when I access a worksheet, e.g. data extends down to row 200 but
screen shows blank rows 201-1000 odd as within the worksheet?

 

[Michael Bednarek]

Can someone kindly remind me how to remove the blank rows that show below
the data when I access a worksheet, e.g. data extends down to row 200 but
screen shows blank rows 201-1000 odd as within the worksheet?

From memory: go to the last+1 non-empty row; select all rows below with
Ctrl+Shift+End; delete those rows (Edit, Delete..., Entire row); save
and open again.

 

[Bagwash]

From memory: go to the last+1 non-empty row; select all rows below with
Ctrl+Shift+End; delete those rows (Edit, Delete..., Entire row); save
and open again.

Yes, that works - many thanks