Removing excess rows in excel

[Phil]

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.

 

[Dave F]

What's the question?

Can't you just delete the excess rows?

 

[Gord Dibben]

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