| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cel Content
hi
text in cel is wrapped i want the cel height to be fixed and then when i am in the cel have the entire contents appear as a pop up of in full I realize it shows at the top of the sheet but isn't there a way to view it on the sheet ? or link to another sheet to view the entry without exploding my format sheet? thanks Nadine |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cel Content
The only way I can think of is to replicate the entry as a comment in the cell.
-- Kevin Backmann "Nadine" wrote: hi text in cel is wrapped i want the cel height to be fixed and then when i am in the cel have the entire contents appear as a pop up of in full I realize it shows at the top of the sheet but isn't there a way to view it on the sheet ? or link to another sheet to view the entry without exploding my format sheet? thanks Nadine |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cel Content
Ohhh that is a great idea !!!
thanks Kevin Nadine "Kevin B" wrote: The only way I can think of is to replicate the entry as a comment in the cell. -- Kevin Backmann "Nadine" wrote: hi text in cel is wrapped i want the cel height to be fixed and then when i am in the cel have the entire contents appear as a pop up of in full I realize it shows at the top of the sheet but isn't there a way to view it on the sheet ? or link to another sheet to view the entry without exploding my format sheet? thanks Nadine |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cel Content
If you have many of these to do a macro is nice.
Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Range("D3:D100") 'adjust to suit Set cmt = r.Comment If cmt Is Nothing Then Set cmt = r.AddComment cmt.Text Text:=r.Text End If Next r End Sub Gord Dibben MS Excel MVP On Thu, 14 Aug 2008 11:23:00 -0700, Nadine wrote: Ohhh that is a great idea !!! thanks Kevin Nadine "Kevin B" wrote: The only way I can think of is to replicate the entry as a comment in the cell. -- Kevin Backmann "Nadine" wrote: hi text in cel is wrapped i want the cel height to be fixed and then when i am in the cel have the entire contents appear as a pop up of in full I realize it shows at the top of the sheet but isn't there a way to view it on the sheet ? or link to another sheet to view the entry without exploding my format sheet? thanks Nadine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Content Bar | Excel Discussion (Misc queries) | |||
| HOW DO I SHOW VAT CONTENT | New Users to Excel | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| freeze content | Excel Worksheet Functions | |||
Hybrid Mode
