Inserting rows disrupts xls comments

okaynowwhat · #5 05-17-2011, 09:50 AM

Quote:

Originally Posted by OTPM

Hi
Simply click on the blue "Quote" button in the bottom right hand corner of your entry and click on the paper clip. Click on browse to find the file to load and then click on upload.
Tony

Okay, try this....

Open the attached file (select Read Only if necessary).

See the comment in cell H17 ("Why do I sometime feel so confined")?

Now click on the blue cell (D12) and Insert a row (the blue cell moves to row 13).

Now go back to the comment (now located at H18).....can't read it right??

Even when you undo "Inset row", the comment remains corrupted.

Of course, it would be no problem to simply resize my rectangle to fit the text in this example but, keep in mind, the xls that i mentioned in my first post has many comments.....there's got to be a better way.

thx
ok

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problems with inserting rows (2007)	Jo-Anne	Word Tables	1	04-06-2011 03:56 PM
Remove highlighted text when inserting comments	Iammuffinman	Word	3	01-27-2011 02:02 AM
Rows to Columns	kyakobi	Excel	5	12-07-2010 03:12 PM
Average of many rows	speedycorn1	Excel	1	10-30-2010 07:54 PM
Comments	davidcs	Word	0	01-05-2010 12:55 AM