Microsoft is in the market for years and has been catering to the computing needs at its best. It is the biggest developer of Operating Systems and numerous other useful applications. The most widely used office application in this world is Microsoft’s Office suit which consists of various applications used for Word editing, Spreadsheet calculations, Database management, Presentation etc. If we talk only about the spreadsheet applications then Microsoft Excel has no second for it. It is one such application which has immense requirement in offices and schools and it has proven its worth for decades by being on the top of the list. Excel is a simple spreadsheet application if looked at a glance but there is a lot it can do. We can save data in tabular form in it, we can perform calculations right there in the tables, we can create sensible and complex reports, we can create presentable graphs and charts, we can do the data analysis very easily and the list goes on. Microsoft Office Excel has been coming as a part of Office Suit since a long time and the latest version was Excel 2010 released in the new Microsoft Office Excel Suit 2010. Office Suit is a kind of product which users use for years without spending extra money on the new versions. Though Microsoft stops supporting the old products after few new releases but there are people who are still using old Suits like that of Office 2000 and Office XP as they still serve their sole purpose of data keeping and editing. In this post I will discuss a feature called as Cell Comment which is present in all the versions of Office Excel and will discuss the steps to add comments and to edit the existing comments.
Before we move towards adding and editing of comments we should know what a comment is? Comment in Excel is extra piece of information stored in any cell. This piece of information has a Memo data type and can save alphanumeric values and even images. This information cannot be used in data analysis or calculations but is a kind of ready reference for any data saved in the cell. Comment is visible only when mouse is hovered over it and not by keyboard selection.
Steps to add a Comment in any cell
Select the cell where you want to place a Comment.
Right click on the cell and then click on Add Comment option from the context menu.
You will get the box for writing comment, so please write the comment and then click anywhere outside the Comment box to save it.
Steps to Edit and existing comment
Select the cell where there is a comment you want to edit.
Right click on that cell and then click on Edit Comment option from the context menu.
By following step2 the comment box turns editable and the text written in it can be modified.
Make the required changes and then click anywhere outside the box to save the changes.