Removing blank rows

  • Thread starter Thread starter Bagwash
  • Start date Start date
B

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?
 
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?
Click to expand...

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.
 
Michael Bednarek said:
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.
Click to expand...
Yes, that works - many thanks
 
Back
Top