In
December 2003
we ran a brief item on adding comments to Excel cells and showed how to
get rid of those little red triangles that clutter the worksheet. Pam
Luedtke, a CPA from Middleton, Wisconsin, suggested another way: With
your cursor in the cell in which you want to attach a comment, click on
Data
and
Validation
, bringing up the
Data Validation
box (see screenshot below).
Type your message under Input message and click on
OK . The message next to the cell appears only when
your cursor is in the cell.
Below is a comparison of the two methods. On the left is the
Validation method; on the right is the conventional
Insert
Comment method.