Solution to Multiline Text in Cell

Vishesh's picture

Solution to the Forum Question in url
http://excelexperts.com/multiline-visible-text-cell

After much R&D and suggestions from the people on Forums through LinkedIn I have come up with something like in the attachment...

AttachmentSize
MultiLineCell-TextBox.xlsm24.3 KB
Nick's picture

one smal bug - I filled all

one smal bug
- I filled all the text, then removed some rows in the middle, and still got the "text won't be visible" message

Vishesh's picture

Nick, Please try the updated

Nick,
Please try the updated attached file.

Nick's picture

open the sheet select all the

open the sheet
select all the text
clear it
then type 1 then press ENTER

=> the 1 (the first row) disappears

... you can get it back with the arrow keys, but it shld be visible