Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show only part of a cell?
I have a lot of text in one cell. Is it possible for me to show only the
first line, and then put a symbol or something that shows all the other text when the cursor touches it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show only part of a cell?
Would using a comment give you what your looking for?
Rgds, ScottO "Leslie" wrote in message ... | I have a lot of text in one cell. Is it possible for me to show only the | first line, and then put a symbol or something that shows all the other text | when the cursor touches it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show only part of a cell?
Maybe...
I put a button from the Forms toolbar completely in a cell that should be on a row that behaves like this. (I used column A, but you could put it anywhere in that row.) Then I assigned the button, this macro: Option Explicit Sub ToggleMe() Dim BTN As Button Set BTN = ActiveSheet.Buttons(Application.Caller) If LCase(BTN.Caption) = LCase("Hide") Then BTN.TopLeftCell.EntireRow.RowHeight = 12.75 BTN.Caption = "Show" Else BTN.TopLeftCell.EntireRow.AutoFit BTN.Caption = "Hide" End If End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Leslie wrote: I have a lot of text in one cell. Is it possible for me to show only the first line, and then put a symbol or something that shows all the other text when the cursor touches it? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want #VALUE! to show as blank cell | Excel Worksheet Functions | |||
how do I use a cell value as part of a cell refereren in a formula | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
help to show formart in reference cell | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |