How 2 Reduce Worksheet Size After Deleting?

  • Thread starter Thread starter Theo
  • Start date Start date
T

Theo

I am working with an Excel 2002 worksheet that originally
had over 63,000 rows. I've deleted most of these rows.
Now only 50 remain. However, if I use a shortcut key to
get to the bottom of my worksheet, it takes me to row
63646. Is there a way to reduce the size of a worksheet
after rows are deleted?

I would just copy the rows I need to a new worksheet, but
there is formatting and characters that I would lose.
Please advise.

Thanks.
 
Back
Top