dimensions (heights) of cell comments

R

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Exc 1
Row Height-Auto Adjust to Content? 5
VBA - (re-) Set a Table Style 2
row height does not move with row when sorting 1
Row height looks good but when I save the file &go to print it hgt 0
Set row height, but allow wrap text 0
How DO I Increase The Excel Cell Comment Data Capacity? 1
rows truncated when printing 0

Top