If I insert comments into a filtered list (Excel 2010) and then remove the filter, each comment remains at its (absolute) location on the spreadsheet as a whole, rather than being close to the cell containing the comment.
For example, in the attached spreadsheet, I have added a comment to cell B121 while a filter is in place (Filtered!B121). While filtered, B121 is on the 39th row of the displayed spreadsheet.
When I remove the filter (see copy in After_Filter_Removed!B121)
, the comment continues to be displayed near the 39th row of the displayed spreadsheet (i.e. near B39), with a line connecting it all the way down to cell B121.
How can I get comments to be displayed in a "relative" rather than "absolute" location, i.e. so that comments are displayed near the cell being commented upon. when filters are added or removed?