View Single Post
 
Old 05-16-2011, 12:37 PM
okaynowwhat okaynowwhat is offline Windows XP Office XP
Novice
 
Join Date: May 2011
Posts: 5
okaynowwhat is on a distinguished road
Question Inserting rows disrupts xls comments

Hi all,

I'm first-time MSO Forums poster and xls newbie who would appreciate a little feedback to a small problem that I can't seem to resolve.

I've made myself a useful spreadsheet that is peppered with pertinent comments. It presents itself well.....that's the good news.

My problem is that whenever I insert a new row to this xls (say midway down the sheet), many of the comments that appear in the cells beneath my new row get disrupted. Either the box around the comment expands (no longer frames the text neatly) or worse......the box around the comment compresses (and the text is no longer legible).

I then have to go and resize the box around each affected comment individually.....there's got to be a better way to go about this!!

Could someone please explain how to insert rows to my spreadsheet without disrupting the existing comments in the cells of rows below??

TIA for any replies

ok

P.S. I'm using Microsoft Office Excel 2003
Reply With Quote