How do you keep a comment close to the cell it relates to in Exce.
I added comments to an excel sheet and then added many rows and moved things
around. Now my comments are all over the place, I wish to keep them a certain distance in relation to the cell, is there anything I can do. |
I'm not sure you can control this.
But you can move them back to where they belong by using some code at Debra Dalgleish's site: http://www.contextures.com/xlcomments03.html#Reset EHN wrote: I added comments to an excel sheet and then added many rows and moved things around. Now my comments are all over the place, I wish to keep them a certain distance in relation to the cell, is there anything I can do. -- Dave Peterson |
All times are GMT +1. The time now is 09:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com