Comments resized to 0 height. Any way to resize all at once?

%3CLINGO-SUB%20id%3D%22lingo-sub-1424752%22%20slang%3D%22en-US%22%3EComments%20resized%20to%200%20height.%20Any%20way%20to%20resize%20all%20at%20once%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424752%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20of%20my%20comments%20have%20been%20resized%20to%200%20height.%26nbsp%3B%20See%20picture%20attached%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Comment.jpg%22%20style%3D%22width%3A%20569px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195178i55BF70DBFE59BEE3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Comment.jpg%22%20alt%3D%22Comment.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20can%20go%20to%20them%20%26amp%3B%20click%20Show%2FHide%20comments%20%26amp%3B%20the%20comment%20can%20be%20selected%20%26amp%3B%20I%20can%20resize%20it.%26nbsp%3B%20Is%20there%20any%20way%20to%20resize%20every%20comment%20in%20the%20spreadsheet%3F%26nbsp%3B%20It%20also%20seems%20like%20they%20keep%20getting%20reset%20to%200%2C%20so%20is%20there%20a%20way%20to%20stop%20that%3F%26nbsp%3B%20I've%20used%20this%20spreadsheet%20for%20years%20without%20issue.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EKristy%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1424752%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424778%22%20slang%3D%22en-US%22%3ERe%3A%20Comments%20resized%20to%200%20height.%20Any%20way%20to%20resize%20all%20at%20once%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424778%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F682665%22%20target%3D%22_blank%22%3E%40KristyKapsner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EKristy%2C%20that's%20with%20macro.%20One%20sample%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.reddit.com%2Fr%2Fexcel%2Fcomments%2F4phot6%2Fmacro_to_resize_all_comment_boxes_to_a_specific%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.reddit.com%2Fr%2Fexcel%2Fcomments%2F4phot6%2Fmacro_to_resize_all_comment_boxes_to_a_specific%2F%3C%2FA%3E%2C%20you%20may%20google%20for%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424845%22%20slang%3D%22en-US%22%3ERe%3A%20Comments%20resized%20to%200%20height.%20Any%20way%20to%20resize%20all%20at%20once%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20Any%20idea%20how%20to%20make%20it%20stop%20happening%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424964%22%20slang%3D%22en-US%22%3ERe%3A%20Comments%20resized%20to%200%20height.%20Any%20way%20to%20resize%20all%20at%20once%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F682665%22%20target%3D%22_blank%22%3E%40KristyKapsner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUnfortunately%20not%2C%20have%20no%20idea%20why%20that%20could%20happen%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

All of my comments have been resized to 0 height.  See picture attached

Comment.jpg

I can go to them & click Show/Hide comments & the comment can be selected & I can resize it.  Is there any way to resize every comment in the spreadsheet?  It also seems like they keep getting reset to 0, so is there a way to stop that?  I've used this spreadsheet for years without issue.

Thanks

Kristy

 
 

 

 

 

 

 
 

 

 

 

3 Replies
Highlighted
Highlighted

@Sergei Baklan  Any idea how to make it stop happening?

Highlighted

@KristyKapsner 

Unfortunately not, have no idea why that could happen