Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments / Freeze Panes
If a comment is made in cell A2 and then freeze panes has been applied, and
you move over to cell D2 the comment becomes hidden behind the rows. Is there anyway the comment should show in front of the row? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments / Freeze Panes
This was written in response to a similar post on this group...
............................ You could use the Data Validation "InPut Message". However, it *only* displays when the cell is selected, and there's no cell "indicator" to make one aware of its existance .............................. Courtesy of Ragdyer... "Roger" wrote: If a comment is made in cell A2 and then freeze panes has been applied, and you move over to cell D2 the comment becomes hidden behind the rows. Is there anyway the comment should show in front of the row? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments / Freeze Panes
CommentBoxes are related to the cell they are attached to....hide the cell
and you hide the CommentBox.....however, the same comments can be applied to more than one cell, such as even to all the populated cells in a row.........just do Copy PasteSpecial Comments.......... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: If a comment is made in cell A2 and then freeze panes has been applied, and you move over to cell D2 the comment becomes hidden behind the rows. Is there anyway the comment should show in front of the row? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments / Freeze Panes
I'm not hiding the cell that has the comment only the cell next to it.
"CLR" wrote: CommentBoxes are related to the cell they are attached to....hide the cell and you hide the CommentBox.....however, the same comments can be applied to more than one cell, such as even to all the populated cells in a row.........just do Copy PasteSpecial Comments.......... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: If a comment is made in cell A2 and then freeze panes has been applied, and you move over to cell D2 the comment becomes hidden behind the rows. Is there anyway the comment should show in front of the row? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments / Freeze Panes
What cell do you have the cursor in when you apply the FreezePanes?
Vaya con Dios, Chuck, CABGx3 "Roger" wrote: I'm not hiding the cell that has the comment only the cell next to it. "CLR" wrote: CommentBoxes are related to the cell they are attached to....hide the cell and you hide the CommentBox.....however, the same comments can be applied to more than one cell, such as even to all the populated cells in a row.........just do Copy PasteSpecial Comments.......... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: If a comment is made in cell A2 and then freeze panes has been applied, and you move over to cell D2 the comment becomes hidden behind the rows. Is there anyway the comment should show in front of the row? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments / Freeze Panes
Explain your question please.
"CLR" wrote: What cell do you have the cursor in when you apply the FreezePanes? Vaya con Dios, Chuck, CABGx3 "Roger" wrote: I'm not hiding the cell that has the comment only the cell next to it. "CLR" wrote: CommentBoxes are related to the cell they are attached to....hide the cell and you hide the CommentBox.....however, the same comments can be applied to more than one cell, such as even to all the populated cells in a row.........just do Copy PasteSpecial Comments.......... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: If a comment is made in cell A2 and then freeze panes has been applied, and you move over to cell D2 the comment becomes hidden behind the rows. Is there anyway the comment should show in front of the row? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments / Freeze Panes
Perhaps you are referring to the fact that the CommentBox dissappears when
you move off the cell it's attached to....well, that's normal.....it will re-appear when you mouse back over that cell, or you can select that cell and right-click and select ShowComment, and it will appear permanently...... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: Explain your question please. "CLR" wrote: What cell do you have the cursor in when you apply the FreezePanes? Vaya con Dios, Chuck, CABGx3 "Roger" wrote: I'm not hiding the cell that has the comment only the cell next to it. "CLR" wrote: CommentBoxes are related to the cell they are attached to....hide the cell and you hide the CommentBox.....however, the same comments can be applied to more than one cell, such as even to all the populated cells in a row.........just do Copy PasteSpecial Comments.......... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: If a comment is made in cell A2 and then freeze panes has been applied, and you move over to cell D2 the comment becomes hidden behind the rows. Is there anyway the comment should show in front of the row? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments / Freeze Panes
That's not my problem
When the comment is attached to A2 and row B, C, D are hidden because freeze pane is applied, and what's on my screen now is Row A, E, F G and so on and I move my cursor to cell A2 the comment will show behind row E. is there anything i could do to bring it in front of row E??? "CLR" wrote: Perhaps you are referring to the fact that the CommentBox dissappears when you move off the cell it's attached to....well, that's normal.....it will re-appear when you mouse back over that cell, or you can select that cell and right-click and select ShowComment, and it will appear permanently...... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: Explain your question please. "CLR" wrote: What cell do you have the cursor in when you apply the FreezePanes? Vaya con Dios, Chuck, CABGx3 "Roger" wrote: I'm not hiding the cell that has the comment only the cell next to it. "CLR" wrote: CommentBoxes are related to the cell they are attached to....hide the cell and you hide the CommentBox.....however, the same comments can be applied to more than one cell, such as even to all the populated cells in a row.........just do Copy PasteSpecial Comments.......... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: If a comment is made in cell A2 and then freeze panes has been applied, and you move over to cell D2 the comment becomes hidden behind the rows. Is there anyway the comment should show in front of the row? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments / Freeze Panes
With the columns B,C,D not hidden, and the CommentBox showing, then
Left-click on the CommentBox to activate it, then move the mouse cursor over to the border of the CommentBox to where it changes shape, and then Left-click there and drag the entire CommentBox over to column E or as far as you wish. hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: That's not my problem When the comment is attached to A2 and row B, C, D are hidden because freeze pane is applied, and what's on my screen now is Row A, E, F G and so on and I move my cursor to cell A2 the comment will show behind row E. is there anything i could do to bring it in front of row E??? "CLR" wrote: Perhaps you are referring to the fact that the CommentBox dissappears when you move off the cell it's attached to....well, that's normal.....it will re-appear when you mouse back over that cell, or you can select that cell and right-click and select ShowComment, and it will appear permanently...... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: Explain your question please. "CLR" wrote: What cell do you have the cursor in when you apply the FreezePanes? Vaya con Dios, Chuck, CABGx3 "Roger" wrote: I'm not hiding the cell that has the comment only the cell next to it. "CLR" wrote: CommentBoxes are related to the cell they are attached to....hide the cell and you hide the CommentBox.....however, the same comments can be applied to more than one cell, such as even to all the populated cells in a row.........just do Copy PasteSpecial Comments.......... hth Vaya con Dios, Chuck, CABGx3 "Roger" wrote: If a comment is made in cell A2 and then freeze panes has been applied, and you move over to cell D2 the comment becomes hidden behind the rows. Is there anyway the comment should show in front of the row? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comments in freeze pane column | Excel Discussion (Misc queries) | |||
Freeze panes doesn't work for everyone | Excel Discussion (Misc queries) | |||
Excel should have a second 'Freeze Panes' option that works in re. | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions |