If you don't like the way Excel displays comments, try using the Data Validation feature to attach text to a cell. Excel will display the information only when a user selects the cell.
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.