View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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?