Removing excess rows in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to remove excess rows that don't contain data but have appeared
when the columns were copied from another worksheet. The escess rows slow
down all the processes and make the file size large.
 
Phil

Go to bottom row of real data range.

SHIFT + End + DownArrow to select to bottom of sheet.

Edit>Delete

Do same for columns to the right of your data.

NOW the IMPORTANT step........save the workbook.

Sometimes save, close and re-open to see changes.


Gord Dibben MS Excel MVP
 
Back
Top