Article View: comp.sys.mac.apps
Article #3317Re: Excel's Last Cell
From: Carl Witthoft
Date: Mon, 09 Jul 1990 17:27
Date: Mon, 09 Jul 1990 17:27
39 lines
1940 bytes
1940 bytes
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##
Technical Details
Message-ID:
<1313@aoa.UUCP>Path:
arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!mailrus!bbn.com!aoa!carlReferences:
<1310@aoa.UUCP> <37446@ucbvax.BERKELEY.EDU>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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