I have alot of text in a cell, I just want to see the top line

[Guest]

All I want is to enter text into one cell and see only the first line and
maybe see the
rest of the text only if I click on this line > can this be done ? I dont
want to
wrap the text cos it leaves big spaces in my worksheet.

 

[Lotus123]

Go ahead and wrap text, but then reset the height of the row back to
regular height. It will then display as much as it can in the single
cell..and then not display the rest (but will show up in the formula
bar when selected).