Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!bbn.com!aoa!carl
From: carl@aoa.UUCP (Carl Witthoft)
Newsgroups: comp.sys.mac.apps
Subject: Re: Excel's Last Cell
Message-ID: <1313@aoa.UUCP>
Date: 9 Jul 90 17:27:26 GMT
References: <1310@aoa.UUCP> <37446@ucbvax.BERKELEY.EDU>
Reply-To: carl@aoa (Carl Witthoft)
Distribution: na
Organization: Adaptive Optics assoc., Cambridge, Ma
Lines: 39

In article <37446@ucbvax.BERKELEY.EDU> dana@are.berkeley.edu (Dana E. Keil) writes:
>In article <1310@aoa.UUCP> carl@aoa. [that's me!!] writes:
>>The question: when I do FormulaSelectSpecial--Last Cell (this is
>>Excel 2.2 at present), the cell chosen is often 'way out in nothingland.
>>But I've tried Clear and even Cutting bunches of rows and columns, 
>>along with copious saves, closes, and re-opens of the document.  Nothing
>>seems to work to convince Excel that there is no data or formatting in al
>>those rows and columns.  Is there anything I can do?
>Clearing (even clearing All) and cutting will not do the trick, what
>you need to do is to select all the empty rows from the current
>"last cell" upto the cell that really is the last cell with something
>in it on the bottom of the spreadsheet and then delete the rows
>(command-K on the keyboard). Do the same for empty columns if necessary
>and then the final trick before closing and re-opening the sheet is
>to be sure that the active cell is one with something in it (that is,
>don't leave the cursor out there in nothingland when you close.
x
Sorry, but this doesn't work.
I got two useful responses: 1) do the above, and "SaveAs", which
seems to work; 2) get Excel2.2a upgrade.  I'll try that next :=)
x
x
x
x
x
x
x
chomp
x
x
x
x


-- 
Alix' Dad ( Carl Witthoft @ Adaptive Optics Associates)
{harvard,ima}!bbn!aoa!carl
54 CambridgePark Drive, Cambridge,MA 02140 617-864-0201
##Another man against violence against women##