Microsoft Excel
--
Questions
--
Followers
Top Experts
Wrap text in merged cells
Dear Experts,
hope to find finally here a working solution:
As soon you merge cells the wrap text function does not work anymore.
Is there a way "via a marco" to keep the function also in merged cells?
I have setup a form including a longer cell to keep text and as wrapping does not work cells have all time adjusted manually to fit the text.
thank you in advance
hope to find finally here a working solution:
As soon you merge cells the wrap text function does not work anymore.
Is there a way "via a marco" to keep the function also in merged cells?
I have setup a form including a longer cell to keep text and as wrapping does not work cells have all time adjusted manually to fit the text.
thank you in advance
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Range("A1").WrapText = TrueAssuming the cell address is Cell A1 and it is a part of merged cell.
Sid
Do you have the Wrap Text option check on the cells that you're merging? If you have this set before merging the cells, they should stay wrapped after.
jppinto
Capture.JPG
jppinto
Capture.JPG
Hi Experts,
maybe I did not explain myself clear enough. Yes, I have switched on text wrapping in each cell before i merged them and after merging the wrapping is activ and works "partly" as the text is wrapping but the respective cell does not extend in size.
If you use wrap text in a "normal" cell the width of the cell is extending as text requires. automatically.
After merging cells this very much used and convenient feature does not work anymore.
I have to extend manually in order to see again the wrapped text.
thanks
maybe I did not explain myself clear enough. Yes, I have switched on text wrapping in each cell before i merged them and after merging the wrapping is activ and works "partly" as the text is wrapping but the respective cell does not extend in size.
If you use wrap text in a "normal" cell the width of the cell is extending as text requires. automatically.
After merging cells this very much used and convenient feature does not work anymore.
I have to extend manually in order to see again the wrapped text.
thanks
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Perfect! Excellently what I was looking for.
thanks to you and Mr. unknown.
Nils
thanks to you and Mr. unknown.
Nils
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.