View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excel Sheet Size

If you CTRL + End on a sheet where does Excel take you?

If far below and right of your actual data range, select all rows below your
actual data and EditDeleteEntire Row

Same for columns to the right.

Do for each sheet.

Now save the workbook.

Close and re-open.

Any change in size?


Gord Dibben MS Excel MVP

On Wed, 4 Feb 2009 14:42:19 -0800, Julie
wrote:

I have a workbook with three tabs and about 100 rows of data in each. It
currently is 63 mb. Does anyone know why it would be so large? I have having
problems savings and opening the document and am afraid it will close down
due to the size. Can anyone know how to avoid getting the workbook to be so
large or what might be the cause? Please let me know! Thanks