Text Wrapping not working as desired.

[Larry S]

I have a workbook containing several worksheets. The specific worksheet of
concern is set up to allow the user to fill in information and as such will
be protected to eliminate the risk of changes. All cells have been set as
Protected except those where the user is allowed to fill in data, AND those
cells have had Wrapping enabled (actually, the whole row (NOT the whole
worksheet) has had wrapping enabled).

However the row is NOT auto expanding when the data is entered, rather the
row remains the height of a single row and never displays more than the
first line of text. This is an issue even with the worksheet unprotected.

Any thoughts?

 

[Larry S]

A couple of addtional details:

- This "cell" is part of group of cell on a single row (they have been
Merged).
- I have attempted to format the row unsing "Auto Fit" under Format/Row.

 

[Gord Dibben]

Larry

Do you have merged cells on this sheet?

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Also revised code for special cases.

http://snipurl.com/dfsm

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP

I have a workbook containing several worksheets. The specific worksheet of
concern is set up to allow the user to fill in information and as such will
be protected to eliminate the risk of changes. All cells have been set as
Protected except those where the user is allowed to fill in data, AND those
cells have had Wrapping enabled (actually, the whole row (NOT the whole
worksheet) has had wrapping enabled).

However the row is NOT auto expanding when the data is entered, rather the
row remains the height of a single row and never displays more than the
first line of text. This is an issue even with the worksheet unprotected.

Any thoughts?

Gord Dibben MS Excel MVP

 

[Larry S]

Thanks - I will look into this. Yes, I have merged cells involved.