I have a project that has always had the following ability :
All cells in a specific column are formatted to WRAP TEXT.
The cells that have wrapped text ... you could double click that specific cell and all of the wrapped text would be displayed along with the initial viewable text.
Then if you single clicked anywhere in the sheet, the cell would collapse to its normal height.
Is there a setting in Excel that accomplishes this (I haven't been able to find it) ... or is there a macro that will accomplish this ?
Thank you.
Bookmarks