How can I globally reduce the height of rows with wrapped text cells in an Excel file to 100 if and only if they are more than 100 in height? The reason I would like this feature is because I cannot always see the top line of text in a cell on myCRT screen if the row height exceeds 100. Many row heights do not exceed 100 and I don’t wish to change all row heights to 100. Currently I have to adjust each row with a height of 100 or more by right clicking on the row heading, selecting “row height” and setting it to 100.
If you know of another way that I can read the top line of all wrapped text no matter what the row height, I’m open to suggestions. I’ve attached an example file Wrap_Example.xls.
