ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Row height is not adjusting after activating Merge Cells & Wrap Te (https://www.excelbanter.com/excel-worksheet-functions/21212-row-height-not-adjusting-after-activating-merge-cells-wrap-te.html)

MHPDallas

Row height is not adjusting after activating Merge Cells & Wrap Te
 
Making spreadsheet order form with description cells that need to expand and
retract text. Low skilled PC users will use this form... Row height is not
adjusting when I: Format/Cells/Allignment/Merge Cells & Wrap Text
together... Auto-height doesn't work either...

Read solution written by fellow MS Group user Jim Rech and did not
understand... I am no MS expert, soooooo. I would greatly appreciate any
other suggestions OTHER than don't try to merge and wraptext together.

Respectfully,
MHPDallas

Gord Dibben

I know you asked for OTHER!! suggestions, but you have three options.

Follow Jim's VBA approach.

Fit manually.

Do not use merged cells.


Gord Dibben Excel MVP

On Fri, 8 Apr 2005 11:15:03 -0700, MHPDallas
wrote:

Making spreadsheet order form with description cells that need to expand and
retract text. Low skilled PC users will use this form... Row height is not
adjusting when I: Format/Cells/Allignment/Merge Cells & Wrap Text
together... Auto-height doesn't work either...

Read solution written by fellow MS Group user Jim Rech and did not
understand... I am no MS expert, soooooo. I would greatly appreciate any
other suggestions OTHER than don't try to merge and wraptext together.

Respectfully,
MHPDallas




All times are GMT +1. The time now is 02:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com