Cell comments

  • Thread starter Thread starter flib
  • Start date Start date
F

flib

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!
 
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
 
Back
Top