Summary - RE: Vexing Excel problem

Hello all,

Thanks all for the Vexing Excel (great band name, don't you think!)
suggestions. It appears that:

1) There is a limitation of 409.50 (546 pixels) for cell row depth
2) There is a 255 character cell column width (not sure how that translates
to pixels)
3) Typing the word "limitations" into the Excel help utility gives you a lot
of good information :o
4) You have to manually expand the row depth, whether or not you've set WORD
WRAP ON in Format/Cells/Alignment to see all the text in the cell
5) That some mysterious force prevents pasted text from wrapping in a cell.
(Probably something to do with hard returns, but not sure)
6) This is a great list!!!

In appreciation,

Bond

-----Original Message-----
From: Monica Mack [mailto:mouse@socrates.Berkeley.EDU]
Sent: Thursday, December 09, 2004 10:33 PM
To: E. Bond Francisco
Subject: Re: [Micronet] Vexing Excel problem

Bond,

I've seen this problem and had to manually resize the cell so all the text
showed.

Monica

At 12:07 PM 12/9/2004, you wrote:
>Hello all,
>
>I've got an Excel 2003 file open. I'm trying to cram a bunch of text
>into a single cell. When I highlight the cell, I see all the text in an
"expansion"
>window, indicating that the text is there. When I deselect the cell, I
>only see the upper 15 or so lines. The rest does not appear, either on
>screen, or in print preview. I've got the cell formatted to WRAP TEXT,
>text direction is CONTEXT, Vertical and Horizontal are set to GENERAL.
>Any suggestions on how I can get the last 15 lines to show up in this cell?
>
>Thanks,
>
>Bond
>-=-=-=-
>E. Bond Francisco
>510-643-5523
>Computer Resource Manager
>CMMS Administrator
>Physical Plant - Campus Services
>UC Berkeley
>
>
>-----------------------------------------------------------------------
>- The following was automatically added to this message by the list
>server:
>
>For information about Micronet, including subscribing to or
>unsubscribing from its mailing list and finding out about upcoming
>meetings, please visit the Micronet Web site:
><http://micronet.berkeley.edu/>.

------------------------------------------------------------------------
The following was automatically added to this message by the list server:

For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web site:
<http://micronet.berkeley.edu/>.
Received on Fri Dec 10 09:53:24 2004