- Excel Book Excerpt
Excel Add a ToolTip to a Cell to Guide the Person Using the Workbook
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Add a ToolTip to a Cell to Guide
the Person Using the Workbook
Problem: Excel offers all sorts of ToolTips to help understand the ribbon icons. It would be cool if I could add a ToolTip to a cell.
Figure 1354 ToolTips provide instant help.
Strategy: You can easily add an informative ToolTip to any cell. The ToolTip will appear when someone selects the cell. Follow these steps:
1. Move the cell pointer to the cell. From the ribbon, choose Data, Data Validation. In the Data Validation dialog, select the Input Message tab.
2. On the Input Message tab, type a title for the ToolTip. In the Input Message area, type instructions for the person filling out the worksheet.
Figure 1355 Write the cell ToolTip on the Input Message tab.
Results: When you move the cell pointer to that cell, an informative ToolTip will appear.
Figure 1356 Help appears for an input cell.
Additional Details: This is an innovative use for the Validation command. You are not actually specifying anything in particular in Allow dropdown, but merely using one of the auxiliary settings in order to have the tool tip display. The validation input message only appears when the cell is selected and might be slightly preferable to cell comments since they will not litter the spreadsheet with tiny red triangles. For information on cell comments, see “Leave Helpful Notes
with Cell Comments” on page 553.
For more resources for Microsoft Excel: