Re: text getting cut off in cell

Tech-Archive recommends: Speed Up your PC by fixing your registry

Gord & Dave, thanks for your help. Here is what happened in my testing:

Yes, the cell in question is one big merged cell. Imagine a report card,
landscape: left 1/3 of the page are many cells that contain subjects &
grades; center 1/3 of the page are many cells that also contain subjects &
grades, days absent, etc.; right 1/3 of the page is this big merged cell
where the teacher can make comments to the parents.

That being said, Dave, your suggestion on manually making row 42 higher
won't work as it affects the grading cells on the left & center areas.

However, I found that if an ALT+Enter is done at the end of EACH typed line,
the text does appear...all the way to the bottom of the comments box! So
thanks for that suggestion!

FYI, the reason I selected Excel for this report card template was the
ability to use data validation in so many areas. Drop-down boxes are used as
much as possible so that any computer-challenged teacher (yes, there are
many) can open the template and fill out their students' data. If you guys,
OR ANYONE ELSE READING THIS POST, think that another program would do a
better job, I'd love to chat about it and would be happy to include a copy
of the report card template for review.

Again thanks,
Judi



"Judi" <tousleyj*at*hotmail*dot*com> wrote in message
news:OAt2ntEIGHA.216@xxxxxxxxxxxxxxxxxxxxxxx
> Using Excel 2003 on WinXP
>
> I created a report card for teachers. There is a comment box which takes
> up cells P2 thru T42.
>
> PROBLEM: When a teacher types a long comment, it shows the entire comments
> in the formula bar, but not in the merged cells intended for comments. The
> text is cut off.
>
> INFO: The merged cells are P2 thru T42. It is catorgorized as Text,
> aligned to left & top, "wrap text" is selected, font is Times New Roman -
> regular - size 8. Data validation is set for any value.
>
> If you'd like for me to send the report card to the group or to someone
> individually, please let me know. Any help is appreciated. We're stumped.
>
> Judi
>


.

Quantcast