To use Data Validation to attach text to a cell, do the following:
- Select the cell.
- Click the Data tab and then choose Data Validation from the Data Validation dropdown in the Data Tools group. In Excel 2003, choose Validation from the Data menu.
- In the resulting dialog box, click the Input Message tab.
- Enter a title and message. The title isn't necessary; you can omit it if you like. Notice that Excel checks the Show Input Message When Cell Is Selection option by default. For this technique to work, you must check this option.
- Click OK.
Now, change the selection and then move the mouse over the cell - Excel doesn't display the text you entered. Select the cell and Excel does display the message.
This technique is easy to implement, but it uses Data Validation in an unusual way so you might not think of it. It's a good tip to share with users because they can easily do it themselves.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.