Hello,
I have a sheet with a mixture of long, wrapped text in merged cells (e.g. A1:A3), and individual values (B1 = "A1", B2= "A2", B3 = "A3")
see xls-1.gif
When I set a filter on column B = "A3", I can only see some of the text in A1, as the row height remains set to whatever I have filtered.
see xls-2.gif
Is there a way to get Excel to display all the text (3 or 4 lines high), i.e to remain that of the merged cell
see xls-3.gif.
Kiteman
Bookmarks