Comment referring to a range of cells, not just single cells / Commenting overhaul
I often need to review workbooks and need to make comments on a range of cells, not just individual ones. When I select a range and 'insert comment' it will only refer to the top left cell and give no relation to the range that was selected.
I overcome this with text boxes over the cells, or by colouring the lot a distinct colour - neither of these are ideal.
What I would like is the function where, on hover of the comment, the cells shade/highlight to reflect that the comment is relating to all those cells, not just the individual one with the red triangle in the corner.
Relating to this, the Excel desktop comment system is antiquated and needs overhauling to be in line with the Excel online version.