Editing cell comments

[eanderso]

I use comments to label cells. I would like to autosize the comments so they will fit the contents and make all the text visible. Right now I have to resize each individual comment. I would like to resize them all at once.

I have had situations when I'll come back into a sheet where the comment boxes have been resized by Excel and the text is no longer fully visible.

 

[Barry Katcher]

After "Insert/Comment", when the comment box appears, double-click on the border to get the "Format Comment" box. Click on the "Alignment" tab and check "Automatic size".

 

[Barry Katcher]

After "Insert/Comment", when the comment box appears, double-click on the border to get the "Format Comment" box. Click on the "Alignment" tab and check "Automatic size".