auto size a merged cell
auto size a merged cell
(OP)
How do you make a merged cell (Columns) auto size in height when someone types in more data than it can display?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: auto size a merged cell
RE: auto size a merged cell
RE: auto size a merged cell
I've also found that if you enable 'wrap text' after the cell is 'overfilled' it won't adjust it. Sometimes selecting the text and then pressing <Enter> instead of simply selecting another cell will get the height to automatically adjust.
I typically make a new spreadsheet, then enable 'wrap text' for the entire spreadsheet (or the required cells), and then paste the data into the new spreadsheet.
Let me know if you find any other techniques.
RE: auto size a merged cell