Categorized | excel tips

How to make your comments in Excel more useful

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:-

Fill Effects


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.

Data Validation

another-way-to-add-comments-in-excelWant 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

third-way-to-show-comments-in-excel-using-formattingIf 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.

Excel Formula, Excel Chart, Excel Macro, Excel VBA, Pivot Table Excel, Excel Dashboard

What Do You Think ?

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


Keep up with the latest stories - Delivered right to your inbox


English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel