If you hover the cursor over the cell, the note will appear. Notes function like Comments in Excel, but there are differences.

While Microsoft Excel's comments and notes tools both let you annotate a cell, they serve different purposes, work in diverse ways, and vary in how they look on a printed Excel worksheet.