You can press Shift/F2, or Insert/Edit Comment. If you wanted to see it
"automatically", when you select the cell, you'd need a macro, but I don't
think this is what you're asking.
Bob Umlas
Excel MVP

"Don" wrote:

How do you make the comments appear when the cell is highlighted opposed to
when the mouse cursor runs over the cell?