Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Adding Comments

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.

webmaster@allaboutoffice.co.uk