Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!usc!ucsd!ucbvax!are.berkeley.edu!dana
From: dana@are.berkeley.edu (Dana E. Keil)
Newsgroups: comp.sys.mac.apps
Subject: Re: Excel's Last Cell
Message-ID: <37446@ucbvax.BERKELEY.EDU>
Date: 6 Jul 90 21:41:43 GMT
References: <1310@aoa.UUCP>
Sender: usenet@ucbvax.BERKELEY.EDU
Distribution: na
Organization: UC Berkeley, Dept of Agricultural & Resource Economics
Lines: 16

In article <1310@aoa.UUCP> carl@aoa. () 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.