While Excel’s Data Validation feature is most commonly used to check data that is entered in a cell, it can also be used to place “Pop Up” notes that will display when a user selects a cell - this might be useful if you want to add additional information or an explanation to a cell entry.



To add a pop up message to a cell:
  1. Click in the cell and on the Data tab, click Data Validation, Data Validation.
  2. Select the InPut Message tab
  3. Make sure that “Show Input Message when cell is selected” is selected.
  4. In the Title box, type a title for the message
  5. In the Input Message box, type the message you want to display.
  6. Click OK