Did you know that there are many other ways in which you can add comments to your excel spreadsheet. Here are a couple of ways:-
You can insert a comment by simply using the Right Click -> ‘Insert Comment’ options. You can then double click on the comment’s border and click on ‘Color and Lines’ tab in the pop-up. In the drop-down for the ‘Colors’ section, ‘choose Fill Effects’. Now select the ‘Pictures’ tab and press the ‘Select picture’ button. This will let you choose the picture that you want. This way you can show your users a graphical message which makes it much more interesting that the default comment in excel. Once you are done, move over the cell and the comment box appears alongwith the image that you want to show your users.
Want to show a comment only when the users selects a cell – well you can simply click on Data -> Validation from the menu options and click on the Input Message tab. Turn on the check box which says ‘Show input message when the cell is selected’ and then go on to enter the message you want to show your users. Now whenever this particular cell gets highlighted, you will see the message appear. As soon as you leave the cell, the message disappears.
Add Colors and Border
If the above don’t sit very well with your sense of subtlety, you want to simply color the comment box and its borders with lighter shades. Simply double click on the comment box’s border and choose the fill and border styles. Sometimes a little change goes a long way in making an impression.