I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, but when I scroll down, only the first line of the comment is visible (everything which fits into the first row). Is there a way to always show the full comment?
I'm using Excel 2010 but a possible solution should preferably also work in Excel 2013.
I think it's clearer with these two screenshots: