I have a cell with wrapped text content in Excel and I want to format the cell so that its height will adjust to fit the content which can span over several lines. How can I achieve this behavior?
feedback
|
|
If it doesn't automatically do it, then place your cursor over the small line between row numbers (ex: between 1 and 2) and double click, this will resize the row (directly above the small line, in the example: 1) so that everything is visible (from a vertical aspect). | |||
|
feedback
|
|
Try
| |||||||||
feedback
|
|
Do you know macro? Put the following code in
inside your Worksheet_SelectionChange subroutine. | |||
|
feedback
|
