Advise would be greatly appreciated. I am working on a work project where columns B - E are merged and wrapped in Row 2. I have gone in and clicked on format and AutoFit Row Height and it will not autofit the row when the text goes beyond the allotted space requiring it to wrap. Any suggestions would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Auto Height Fill
- Thread starter RVenable
- Start date
-
- Tags
- autofit row height
CyrusTheVirus
Well-known Member
- Joined
- Jan 28, 2015
- Messages
- 749
- Office Version
- 365
- Platform
- Windows
Hi RV,
Welcome to the forums.
Unless there is a particular reason why something is being merged, then it is almost NEVER advisable to merge cells... it causes countless issues. In fact, the main reason to use the merge feature is to UNMERGE whatever others have actually merged.
In lieu of the merge feature, unmerge selection first, then highlight the selection, then hit Ctrl+1, then click 'Alignment', then make the horizontal 'Center Across Selection'.
Hope this helps.
Welcome to the forums.
Unless there is a particular reason why something is being merged, then it is almost NEVER advisable to merge cells... it causes countless issues. In fact, the main reason to use the merge feature is to UNMERGE whatever others have actually merged.
In lieu of the merge feature, unmerge selection first, then highlight the selection, then hit Ctrl+1, then click 'Alignment', then make the horizontal 'Center Across Selection'.
Hope this helps.
Last edited:
Upvote
0
Similar threads
- Question
