G
Guest
I am using comments exclusively as notes for individual cells in Excel 2000:
1) I need to anchor each comment to its cell so it is in the same location
relative to the cell when I reedit it later. Currently, when I add or delete
rows or columns, the comments for cells below and to the right of the
addition/deletion are shifted away from the cell in edit mode (extremely
annoying). I changed the Format Comment Properties to "Move but don't size
with cells", this reduced the movement but didn't eliminate it, so comments
can still eventually show up miles away from the cell in edit mode after
several row/columns are added or deleted.
2) I need to size a comment box to fit a multi-line comment and have it
stay the same size that I chose. Currently adding or deleting rows changes
the size of the box and can shrink it down to nothing.
3) I would like to change Format Comment defaults (such as Properties) but
don't know how.
1) I need to anchor each comment to its cell so it is in the same location
relative to the cell when I reedit it later. Currently, when I add or delete
rows or columns, the comments for cells below and to the right of the
addition/deletion are shifted away from the cell in edit mode (extremely
annoying). I changed the Format Comment Properties to "Move but don't size
with cells", this reduced the movement but didn't eliminate it, so comments
can still eventually show up miles away from the cell in edit mode after
several row/columns are added or deleted.
2) I need to size a comment box to fit a multi-line comment and have it
stay the same size that I chose. Currently adding or deleting rows changes
the size of the box and can shrink it down to nothing.
3) I would like to change Format Comment defaults (such as Properties) but
don't know how.