Excel 2007 - Editing Comments

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom K - 13 Aug 2007 15:48 GMT

When I right-click a cell to edit an existing cell comment in Excel 2007,
the comment text box jumps down to row 399. My spreadsheet ends after row
50. I can edit the comment text box, but must then CNTL-Home to go back to
the top of the worksheet and scroll to the area where I was working. This
doesn't happen when creating a new comment, or when mousing over to view an
existing comment--in both cases the comment is just to the right of the
cell. Just happens when editing a comment.

Does anyone know why this happens? I've made sure there is no formatting or
other info in rows 51-399. Is this possibly just a bug?

Thanks.

Reply to this Message

Jim Rech - 13 Aug 2007 18:52 GMT

A comment has a double life, one as an object or a shape when you are
editing it, and one as an image of that shape when you mouse over it. As a
shape the comment can be moved and sized freely like any shape but as an
image it always hovers in the same position next to its cell.

Somehow this comment shape was moved, perhaps by inserting rows, I don't
know. You can drag it back with the mouse. And also with this simple
macro:

''Select cell with comment
''Needs work to work with cells in row 1 or last column.
Sub MoveCommentShape()
On Error Resume Next
With ActiveCell.Comment.Shape
.Top = ActiveCell.Top - 5
.Left = ActiveCell.Offset(0, 1).Left + 5
End With
End Sub

A comment shape should not be set to move or size with column and row
inserts, etc. When editing a comment shape right-click its border and pick
Format Comment. On the Properties tab make sure that "Don't move or size
with cells" is selected.

Signature

Jim

| When I right-click a cell to edit an existing cell comment in Excel 2007,
| the comment text box jumps down to row 399. My spreadsheet ends after row
[quoted text clipped - 8 lines]
|
| Thanks.

Reply to this Message