Forum Discussion
Excel - random movement of notes when rows inserted
LaurieB1950 , that's the question is to this community Welcome to the Excel group. (microsoft.com) and could you please explain step by step what are doing (e.g. add Note to C3, insert row above rows #3, etc)
I have set up a spreadsheet with about 200 rows. On each row, in the second cell, I have inserted a note to tell me where to find the scanned document that was used to input the information for that row. As it is being created, the note is aligned with the row for both hovering and editing. However, if I insert any number of rows (1+) into the spreadsheet, all of the rows after the insertion point behave differently. If the mouse is hovered, the note appears aligned with that row, but if I "edit the note" the note has moved a random distance from it's respective row and the size changes as well, despite having the property set to auto-size. Sometimes the notes only move a couple rows, sometimes it is a number of scroll pages, completely off the screen containing the row I am working on. Editing the note requires that I see the data on that row so I have to drag the note back to the original location on that row. I have tried the three options for the note property (Do not move with cell and do not resize, move with the cell but do not resize, and move with the cell and resize) but none of them lock the note alignment.