| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I have alot of text in a cell, I just want to see the top line
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. |
|
#2
|
|||
|
|||
|
I have alot of text in a cell, I just want to see the top line
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). -- Lotus123 ------------------------------------------------------------------------ Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611 View this thread: http://www.excelforum.com/showthread...hreadid=483873 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text disappears when word wrap is used | Excel Discussion (Misc queries) | |||
| Wrap Text | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| how to hyperlink text to a cell | New Users to Excel | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Hybrid Mode
