Excel comments moving and changing sizes

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.
 
S

Shane Devenshire

Hi,

You might right click on the comment border and choose Format Comment,
select the Properties tab and play with the options to see if any work better
for you.
 
J

JStevans

Thanks, Shane. I have tried them all - no joy.

After further experimentation I have more or elss concluded that this is
caused by a bug in the outlining feature. When I do not collapse and/or
expand my spreadsheet using the outline feature the comments seem to stay
put. I haven't spent enough time on it to be sure but this may be the cause.

J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top