Awesome Excel tip #3

Display a message on a cell and not a comment

Data validation in Excel is very powerful and very useful for helping users work with data in cells or ranges of cells. Instead of putting a comment on a cell (which pops up even if you are not working on that cell), consider using a message feature instead!

When on the cell you want the message to display with:

  1. Click the Data tab
  2. In the Data Tools group, select the Data Validation tool
  3. Select the 'Input Message' tab
  4. Enable 'Show input message when cell is selected'
  5. Give your message a title (optional) and text


Step 1

Step 2

Step 3

End result