Compact a S'Sheet 1-2-3

[NevG]

Hi

Can anyone tell me of a way in Lotus, other than using WinZip or something similar, to compact a spreadsheet.

Is there a way of compacting it through Lotus or is this a stupid question.

Im looking for something ilke the Compact & Repair database in MS Access

Thanks for any help

Nev G

 

[DaleWatson123321]

Nev G,

To my knowledge, there is no "automatic" method of "compacting" a spreadsheet in the terms you describe - i.e. within the spreadsheet itself.

I believe the best method to "compact" a spreadsheet, is to do delete any unused columns and rows. Such rows might have been "formatted" in the past and are no longer in use, and if so, will consume memory and file space.

The quick method of determining the &quot;last cell in use&quot; on a worksheet is to use the <End> <Home> method. After hitting the <End> key, followed by the <Home> key, your cursor will go to the cell which is at the &quot;juncture&quot; of the &quot;last column&quot; in use, and the &quot;last row&quot; in use.

Then manually determine the &quot;end point&quot; of your &quot;valuable&quot; data. If there is a &quot;difference&quot; between the two &quot;end points&quot;, then you have identified an area where you can &quot;compact&quot; the worksheet. Do this by deleting those columns to the right of your &quot;valuable&quot; data, and by deleting the rows below your &quot;valuable&quot; data.

Hope this helps. Please advise.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca