Fix Those Wandering Excel Comments

Do you ever open an Excel workbook, and find that tragedy has struck your comments? You spent hours inserting those comments, and making them just the right size and shape. Then, for no apparent reason, everything changes.

Some comments have flattened to a thin line. Other comments are so small that you can barely read the first word. A few comments have wandered far from their cell, and the connecting line stretches across the entire window.

What a mess! Fortunately, you can quickly get things back in place, by using an Excel macro or two.

Put Comments Back in Place

If your comments have slithered across the spreadsheet, you can use this macro to put them back in their parent cell.

12 Responses

1) I set the width/height based on parsing the comment text into numbers of characters and numbers of carriage returns to estimate it that way2) I insert at the top of the comment a date stamp, which gives a record of when it was raised, and hence how old it is.

Amazing, this has saved me hours. I have a macro that can insert thousands of comments and some some reason a portion of these decided to change size and move hundreds of rows away. This has cleaned it all up!