It can often be useful to make a
note about a value by adding a comment to a cell. To do this, click on the cell that you want to attach the comment to and then click on the Insert drop-down menu and choose Comment. A box appears where you can type your comment. When you have finished just click outside of the box and the
comment will be entered. A small red mark will be placed in the corner of the cell to show there is a comment there and the comment will be displayed when you hover over the cell. You can display all the comments permanently while you are viewing your spreadsheet by clicking on the View drop-down menu and choosing Comments. Some displayed comments can be seen in below:
If you click on the File
drop-down menu and choose Page Setup and then click on the Sheet
tab you can set whether you want comments to be printed and where they will be
placed as shown below. You can either print your
comments where they are located on the spreadsheet or at the end. It is best to print comments at the end if there are a lot in your spreadsheet.
Here is an example of how our
comments would print at the end of the document:
Click here to
return to the Excel index.