Excel 2020: Add a Tooltip to a Cell with Validation
March 04, 2020 - by Bill Jelen
In Excel 2020: 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
This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.