How to Insert and Modify Cell Comments in a Spreadsheet

The 3-D cells we made were cool, but what else can we do with cells? We all use the handy dandy post it notes. They are a life saver to quickly remind us of important points that we might forget with all the chaos that goes on at work. Well you can actually use this same principle within Excel spreadsheets by using this electronic equivalent of the “post it note.” You can do this by inserting a comment. In this short lesson, you’ll learn how to insert a cell comment and customize it.

1. We’ll use the following spreadsheet for our example – this spreadsheet contains salespersons and profit information for a beverage distribution company. We want to insert a comment within the Mary Roberts row to indicate that she continues to be the top seller for past couple of months. First, select cell B9 and go to Insert>Comment and a box with your name will appear where you will type in your brief reminder.

modify cell1
modify cell2

2. Now, go ahead and enter your comment (remember to keep it brief and concise). In this example, I wrote that “Mary Roberts continues to be the top seller.” Once you’re done, click out of the cell. Whenever you want to view the comment, just gently place the cursor over the tiny red triangle within the cell where you inserted the comment, and the comment box will appear.

modify cell3

3. Now if you want to change the look (font type, color, etc) of the comment, select the cell where you placed the comment and right click, and go down to “Edit Comment” and select this option. Now you can play with the look of the words; in this example, I selected the whole comment and made the font blue in italics and bold – remember you can change the font colors and styles by using the format menu or the top formatting buttons.

modify cell4

modify cell5

4. Now every time you click on the comment it will appear as you customized it. Well done! You learned how to insert the electronic equivalent of the sticky note in a excel spreadsheet.

modify cell6

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)

Related Posts