View Single Post
  #1   Report Post  
Bill Davis
 
Posts: n/a
Default Comment Box Auto-sizing

Existing Conditions:
Single Excel Sheet 150rx10c
Every row has at least 1 to 2 comments attached to a cell
Edit/resizing the rows and columns has trashed the sizing of the associated
comment boxes. Some are tiny some are thinned out so that no text displays etc

Help Needed:
Comprehensive way to fit all comment boxes to content (ie resize to fit like
you do with rows and columns)
This document will be edited for row/cell size regularly so a repeatable or
'permanent' auto-size would be awesome.

Really don't want to have to keep manually re-sizing a couple hundred
comment boxes so any help you can give would be greatly appreciated.