File Size

[Bernie Beal]

MS Excel Newsgroup:

I created two files in the form of Tables. One is a single page and contains
762 Kb memory. The other is at least four pages, depending on the printing
selection, and it contains only 77 Kb memory.

Can anyone enlighten me about this to improve my understanding of MS Excel?

Thanks,
Bernie Beal.
(e-mail address removed)

 

[Gord Dibben]

Bernie

On the larger file, CRTL + End to see where Excel takes you.

Excel is notorious for over-estimating the "used range" if data was entered
then deleted/cleared from the far reaches of the sheet..

If far below and/or to the right of your "real" data range, select all rows
below the real range and Edit>Delete>Entire Rows.

Do the same for columns to the right.

SAVE and CLOSE then re-open the workbook. What size is it now?

Gord Dibben Excel MVP

 

[Dave Hawley]

Hi Bernie

Try these 2 links
http://www.ozgrid.com/Excel/ExcelProblems.htm

http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****