Excel 2020: Add a Tooltip to a Cell with Validation - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Thursday, March 12, 2020

Excel 2020: Add a Tooltip to a Cell with Validation

Excel 2020: Add a Tooltip to a Cell with Validation

Add a Tooltip to a Cell with Validation. Photo credit: oldskool photography at Unsplash.com.
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.
There is a lot of subtle information in this image. First, on the Data tab of the Ribbon, choose Data Validation. The Data Validation dialog is shown - it has three tabs across the top: Settings, Input Message, and Error Alert. Currently, the Allow box on Settings is set to Any Value. An arrow indicates that you will soon be using the Input Message tab.
On the Input Message tab, type a title and a message. Click OK.
In the Input Message tab of Data Validation, type a Title and an Input Message.
The result: a tooltip that will appear any time the cell is active:
After setting up the Input message, select the cell. A yellow tooltip appears with the Title in bold and the message. In this case, it is telling the person using the spreadsheet where to find Adjusted Gross Income n their tax form.
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

No comments:

Post a Comment