J
JStevans
Hi,
I have a large spreadsheet (500 rows x 8 columns) with many comments.
I am doing extensive editing, many changes including moving and/or
copy-paste of multiple rows at a time.
I am also using Excel's outlining feature.
I have set Excel to display the comments at all times, that is very helpful
to me during the editing process.
For some reason the displayed comments are frequently changing size
(becoming taller though never wider) and position. Sometimes they are
suddenly 30, 70, or even 100 rows down from where they were when I last saw
them.
For example, after some editing (maybe moving some rows, deleting others,
all standard Excel editing) the comment for Cell-D in Row-5 will now be 30,
40, or even 100 rows lower. It still has that "tie line" to the correct cell.
It's just that the comment itself is way, way, way down the spreadsheet.
So, before the comment is useful, or the spreadsheet printable, I need to
find every comment that has been relocated, drag them back to where they
belong, and then I can move forward. But, a while later, many of them are
messed up again.
When one right-clicks on the border of a comment "Format comment" appears as
a choice. When I go there one of the tabs is "Properties" and it offers three
radio buttons:
* Move and size with cells
* Move but don't size with cells
* Don't move or size with cells
None of these solve the problem.
My questions are:
1. Why don't any of these three choices stop the comments from changing size
and position?
2. Is the use of outlining the cause of the problem?
3. Is there a global setting for the comment properties so I do not need to
manually set this property for every comment I make?
Thanks.
I have a large spreadsheet (500 rows x 8 columns) with many comments.
I am doing extensive editing, many changes including moving and/or
copy-paste of multiple rows at a time.
I am also using Excel's outlining feature.
I have set Excel to display the comments at all times, that is very helpful
to me during the editing process.
For some reason the displayed comments are frequently changing size
(becoming taller though never wider) and position. Sometimes they are
suddenly 30, 70, or even 100 rows down from where they were when I last saw
them.
For example, after some editing (maybe moving some rows, deleting others,
all standard Excel editing) the comment for Cell-D in Row-5 will now be 30,
40, or even 100 rows lower. It still has that "tie line" to the correct cell.
It's just that the comment itself is way, way, way down the spreadsheet.
So, before the comment is useful, or the spreadsheet printable, I need to
find every comment that has been relocated, drag them back to where they
belong, and then I can move forward. But, a while later, many of them are
messed up again.
When one right-clicks on the border of a comment "Format comment" appears as
a choice. When I go there one of the tabs is "Properties" and it offers three
radio buttons:
* Move and size with cells
* Move but don't size with cells
* Don't move or size with cells
None of these solve the problem.
My questions are:
1. Why don't any of these three choices stop the comments from changing size
and position?
2. Is the use of outlining the cause of the problem?
3. Is there a global setting for the comment properties so I do not need to
manually set this property for every comment I make?
Thanks.