Add a ToolTip to a Cell in an Excel Spreadsheet
RSS
 View all Hubs
See what's in...

Microsoft Excel: Add A Tooltip To A Cell To Guide The Person Using The Workbook

Article by Mr Excel (11,376 pts )
Published on Aug 19, 2008
Problem: Excel offers all sorts of tooltips to help you understand the toolbars, as shown in Fig. 1492. Wouldn’t it be cool if you could add a tooltip to a cell?
417 views

See all Microsoft Excel tips

Strategy: You can easily add an informative tooltip to any cell. The tooltip will appear when someone selects the cell.

1) Move the cell pointer to the cell. From the menu, choose Data – Validation. On the Validation dialog, go to the Input Message tab, as shown in Fig. 1493.

2) On the Input Message tab, type a title for the tooltip. In the message area, type instructions for the person filling out the worksheet, as shown in Fig. 1494.

Result: When you move the cell pointer to that cell, an informative tooltip will appear, as shown in Fig.

1495.

Summary: Using the Input Message of the Validation dialog allows you to create helpful tooltips, which can appear in any cell.

Commands Discussed: Data – Validation

See all Microsoft Excel tips

Images

Fig. 1492Fig. 1493Fig. 1494Fig. 1495

Bright Hub - Science & Technology Articles, Buyer's Guides, How-To Tips and Software Reviews
About Bright Hub | Contact Us | Terms of Use | Privacy Policy | Copyright Policy | ©2008 Bright Hub Inc. All rights reserved. Page copy protected against web site content infringement by Copyscape