Comments - stop resizing and moving comments
When hiding and un-hiding rows, or moving rows, or having freeze panes on, the comments on cells for no reason stretch or move far down one's sheet. It would be really nice if the size of the comment stays as is and it doesn't move all over.
Col Delane commented
This is absolutely necessary if you use Autofilters or Grouping.
I have adapted VBA code [ posted by Faith Granger on http://www.mrexcel.com/forum/excel-questions/796938-macro-put-all-comments-back-where-they-belong.html ] to auto-size and relocate cell comments on the active sheet or entire workbook (user choice of scope)