Cell comments

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

flib - 15 Oct 2004 09:49 GMT

Hi there,

Is there any way to stop cell comments resizing when inserting new rows
above or below the cell with the comment, as at the moment if I insert a
row above a row which has a cell with a comment, the comment will resize
in height and it's very very very annoying.

Thanks!

Signature

flib

Reply to this Message

Debra Dalgleish - 15 Oct 2004 13:14 GMT

You could set the properties of the comment so it doesn't size with the
cells:

Select the cell that contains the comment
Choose Insert>Edit Comment
Click on the border of the comment to select it
Choose Format>Comment
Select the Properties tab
Select Move but don't size with cells
(or -- Don't move or size with cells)
Click OK

> Is there any way to stop cell comments resizing when inserting new rows
> above or below the cell with the comment, as at the moment if I insert a
> row above a row which has a cell with a comment, the comment will resize
> in height and it's very very very annoying.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message