Why do comments in excel move

This tip applies to Microsoft Excel , , , , , and Excel in Office You can find a version of this tip for the older menu interface of Excel here: Anchoring Comment Boxes in Desired Locations. With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author.

He is president of Sharon Parq Associates , a computer and publishing services company. Learn more about Allen Word is quite flexible in how you can configure the user interface.

This tip explains how you can customize a toolbar so Getting a word count for an entire document is easy. What you may not know is that some versions of Word can also provide When you subtract two numbers from each other, you have a certain expectation of what Excel should deliver. What if you Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr.

Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Comments can be very helpful in a worksheet. After they are added, you may want to change what they contain. Here's how Need to find that misplaced comment in your worksheet?

It's easy to do using the Find and Replace capabilities of Excel. Have you ever chosen to edit a comment, only to find that the comment is quite a ways from the cell with which it is Enter your address and click "Subscribe.

Your e-mail address is not shared with anyone, ever. Maximum image size is 6Mpixels. Images larger than px wide or px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. Great site, will help me very much, thank you. I have a question however i.

I have a spreadsheet of a few hundred rows and some 18 columns. In each row there ire comments added to typically 4 cells in each row. Some time back evertything went haywite and all that shows now are lines from cell leading to no comments but they go all over the place. Is there a way to get this back under control or have I just put too much data in for the program to manage showing comment upon hovering over those particular cells?

Similarly with graphs you need to right click on the graph and search for the same option within properties to specify how a graph should re act when cell sizes are changed. The different versions of Excel have put this in different places but you can see an example in the Excel Charts Chart Area video clip.

These and more are available in our Excel Dashboard course. See how to find and correct these error types with a Spreadsheet Auditing Tool that will find:. You can also see more on the free Auditing an Excel spreadsheet course link to the software is included in the course as well.

Stop excel comments moving The problem with objects on an Excel spreadsheet graphs, pictures, comments or anything that hovers over the cells is that when you make changes to the size of rows or columns, these shapes tend to move and resize with them.

Notice that with this method you can control the following aspects of a comment: Font size, colour, effects and more Alignment of the text within a comment Colours, widths and style of lines Size Treatment of comments when protection is enabled, and Margins within the comment box Similarly with graphs you need to right click on the graph and search for the same option within properties to specify how a graph should re act when cell sizes are changed.

What a mess! Fortunately, you can quickly get things back in place, by using an Excel macro or two. Use the sample macros below, to fix wandering Excel comments, and to make them the correct size again.

If your comments have slithered across the spreadsheet, you can use this macro to put them back in their parent cell. For comments that have shrunken to thin slivers, you can use this macro to get them back to a normal size. 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!

Thank you!!! I was completely new to macros with a huge spreadsheet full of comments. Thank you for this link to what the heck to do with the macro! So helpful. This whole discussion is saving my sanity.. Had to resort to Google as IT could not fix this issue at work. Thank you so much for saving my spreadsheet! Thanks Navneet. Thank you so much! I tried to install the macros but, when I click alt-F11 nothing happens.

This is all new to me. Never installed a macros before. I just want my comments in excel sheet to quit wandering.