Excel 2019: Add a Tooltip to a Cell with Validation
March 14, 2019 - by Bill Jelen
In Excel 2019: Old Style Comments Are Available as Notes, I suggested using Notes for a help system. The problem with notes: it is possible to arrow in to a cell without ever hovering over the red triangle and the note might be missed. You can use the Data Validation dialog to set up a tooltip for a cell. The tooltip is only visible when the cell is the active cell.
Data Validation is found towards the right side of the Data tab in the Ribbon. I end up using Alt+D L because I always have a difficult time finding the Validation icon. Normally, most people use the Settings tab in Data Validation to control what can be entered in a cell. You will skip the Settings tab and go to the Input Message tab.
On the Input Message tab, type a title and a message. Click OK.
The result: a tooltip that will appear any time the cell is active:
Title Photo: oldskool photography at Unsplash.com