Show comments/notes when cell is selected in Excel

When working with Excel worksheets, you may sometimes want helpful information to appear automatically when a specific cell is selected. This can be useful for showing instructions, reminders, explanations, or extra details without filling the worksheet with too much visible text.
Although Excel does not provide a built-in feature that displays a traditional comment or note only when a cell is selected in exactly the way many users expect, there are several practical ways to achieve a similar result. In this guide, you will learn three effective methods to show comments or notes when a cell is selected in Excel.

Why show comments or notes when a cell is selected?

Understand the difference: Comments vs. Notes in Excel

Show Comments (Notes) When a Cell Is Selected in Excel

• Method 1: By using Data Validation
• Method 2: By using VBA code
• Method 3: By using Kutools for Excel

Conclusion

Why show comments or notes when a cell is selected?

In Excel, comments—called Notes in Excel 365—are often used to store extra information, reminders, or explanations. By default, these notes only appear when you hover over a cell. However, displaying them when a cell is selected can make a worksheet much clearer and easier to use. This is especially helpful when you want to provide input guidance, highlight important details, reduce entry errors, or make shared worksheets more user-friendly. This is especially useful when:

By making notes easier to view, you can improve both efficiency and accuracy when working in Excel.

Understand the difference: Comments vs. Notes in Excel

Before using these methods, it is important to understand the difference between Comments and Notes in modern Excel.

If your goal is to display a small yellow-style popup when selecting a cell, you are usually working with Notes, not threaded comments.

Show Comments (Notes) When a Cell Is Selected in Excel

If you want to display comments or notes more easily while navigating through cells, there are several practical ways to do it. In the following sections, we will introduce three useful methods to help you show comments or notes when a cell is selected in Excel.

Method 1: Show comments (notes) when a cell is selected with Data Validation

If your goal is to show a helpful message whenever a user selects a specific cell, Data Validation Input Message is the easiest built-in method in Excel. This method does not create a traditional comment or note, but it displays a pop-up message as soon as the cell is selected.

1. Select the cell or range where you want the message to appear.

2. Go to click Data > Data Validation > Data Validation, see screenshot:

3. In the Data Validation dialog box, go to the Input Message tab:

• Check the option Show input message when cell is selected.

• In the Title box, enter a short heading for the message.

• In the Input message box, type the note, instruction, or reminder you want to show.

• Click OK.

Result: Now, when the selected cell is clicked, the input message will appear automatically.

Method 2: Show comments (notes) when a cell is selected with VBA code

If you want the comment or note to pop up automatically whenever you click a cell, VBA is the most effective solution. With a simple macro, Excel can display the note for the active cell and hide notes from previously selected cells. This method works best with Notes, not modern threaded comments.

1. Open the worksheet where you want this behavior. Right-click the sheet tab, then choose View Code.

2. In the opened VBA editor, copy and paste the following code into the worksheet code window:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim cmt As Comment
    Dim ws As Worksheet
    Set ws = Me
    For Each cmt In ws.Comments
        cmt.Visible = False
    Next cmt
    If Not Target.Comment Is Nothing Then
        Target.Comment.Visible = True
    End If
End Sub

Result: Now, when you select a cell containing a note or comment, that note will appear automatically.

Method 3: Show comments (notes) when a cell is selected with Kutools for Excel

For users who want an easier alternative to Data Validation or VBA, Kutools for Excel offers a more convenient way to work with comments and notes. With its user-friendly tools, you can quickly add, manage, and display notes in your worksheet without writing any code. This makes it a great choice for creating clearer, more interactive spreadsheets while saving time and effort.

Kutools for Excel offers over 300 advanced features to streamline complex tasks, boosting creativity and efficiency. Integrated with AI capabilities, Kutools automates tasks with precision, making data management effortless. Detailed information of Kutools for Excel...         Free trial...

1. Click Kutools > More > Always Show Comments, see screenshot:

Result: After enabling this feature, clicking a cell with a comment will keep the comment window visible until another cell is selected.

Conclusion

Showing comments, notes, or helpful messages when a cell is selected in Excel can make your worksheet more interactive, clearer, and easier to use.

If you only need a simple built-in solution, Data Validation Input Message is the quickest method. If you need more flexibility and want customized pop-up behavior, VBA is a powerful choice. If you prefer a more convenient and user-friendly solution without coding, Kutools for Excel can help simplify comment and note management.

The best method depends on your needs, your Excel skill level, and whether you want a built-in, programmable, or productivity-enhanced solution. Choose the one that fits your workflow best, and make your Excel worksheets easier for everyone to understand and use.