I have a spreadsheet where columns A-D are merged and when a significant amount of text gets entered into a cell it wont auto size to show all the text and when I double click in-between the rows rather than expanding to show all the text it shrinks to only show 1 line. I have tried selecting format and autofit column width and also tried autofit row height and neither has seemed to help, so I have resorted to manually expanding the row height to accommodate all the text. Any suggestions?
-
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.
Taul
Well-known Member
- Joined
- Oct 24, 2004
- Messages
- 767
- Office Version
- 2019
- Platform
- Windows
I would suggest you do not merge the cells.
Put the data in the column “A” cell only, then select the cells “A to D” and then:-
Click on “Wrap Text”
Format – Format Cells – Alignment – Horizontal – Centre across selection. – click ok
You will then be able to double click the grey line between the row numbers to auto fit the row height.
Put the data in the column “A” cell only, then select the cells “A to D” and then:-
Click on “Wrap Text”
Format – Format Cells – Alignment – Horizontal – Centre across selection. – click ok
You will then be able to double click the grey line between the row numbers to auto fit the row height.
Upvote
0
Similar threads
- Question
