I have inherited a workbook. many of the sheets have rows where the height has been manually changed.
There are many rows that have text wrapped across merged cells.
Often the text is so long that the row height is not high enough to allow all the text to show (see attached).
I need to be able to identify instances where not all the text is showing. Once a I have foundthese instances I will adjust the row height manually.
What is the best way to identify such instances?
Kind Regards
Allister
There are many rows that have text wrapped across merged cells.
Often the text is so long that the row height is not high enough to allow all the text to show (see attached).
I need to be able to identify instances where not all the text is showing. Once a I have foundthese instances I will adjust the row height manually.
What is the best way to identify such instances?
Kind Regards
Allister
Book11.xlsx | ||||
---|---|---|---|---|
B | C | |||
6 | The quickbrown fox jumped over the lazy dog. | |||
7 | ||||
8 | Apple Apple | |||
9 | ||||
10 | The quickbrown fox jumped overe the lazy dog. The quickbrown fox jumped overe the lazy dog. | |||
Sheet1 |