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.

What's the question?

Can't you just delete the excess rows?
--
Brevity is the soul of wit.


"Phil" wrote:

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.

EditDelete

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

On Thu, 31 Aug 2006 06:41:02 -0700, Phil wrote:

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.