dimensions (heights) of cell comments

[R Vaughn]

Just a general question: Why do the heights of a set of existing cell
comments in a spreadsheet change when I insert rows into the spreadsheet?
There does not appear to be any pattern...some of the comments shrink while
the heights of others increase.

 

[Gord Dibben]

Depends upon how you set the properties under>Format>Properties.

You can select "don't move and size with cells" to keep it same size.

You are probably set to "move and size with cells" which expands or shrinks
the comment when deleting/inserting rows.


Gord Dibben MS Excel MVP