Share this page
Excel - Comments
The comments allow the users to quickly recall important information about the worksheet or to place comments for others to read and react to. It can be an important communication tool for a group working on the same worksheet. They are usually hidden until you need to see them. But you can also see them at all times if desired. This page will show you how to get the most out of this tool.
You can have all the comments options available in a single toolbar.
From the View menu, select the options Toolbars and Reviewing.
Here is a short description of that toolbar
But you can always add, change or delete a comment without using the comments toolbar.
Place the cursor in the A1 cell.
From the Insert menu, select the Comment option.
A yellow box, similar to a "post-it" note will appear beside the cell. You can write you comment inside that box.
For this exercise, enter your name and a comment of your choice.
A small comment indicator will appear at the upper right of the cell. You can place your cursor on it at any time to see the comment.
Place the cursor over the cell with the comment.
A comment box will appear at that time.
Sometimes, it's better to see the comment just for a moment. But at other times, you want to leave it open on the worksheet to remember what need to be done.
Place the cursor in the cell with the comment.
The comment of the cell will appear. It will remain on the worksheet until you hide it again. It's also possible to open all the comments at one time.
From the View menu, select the Comments option.
All the comments on the worksheet will appear.
Repeat the steps to mask the comments.
You can always change a comment just by clicking on it.
Place the cursor on the cell with a comment.
From the Insert menu, select the Modify a comment option.
From the context menu, select the Edit comment option.
Change the comment as you desire.
This option is also available from the Reviewing toolbar.
Place the cursor in the cell with the comment to view it.
The comment will always remain connected to that cell by an arrow. You can also change the size of the comment box by dragging the dimension squares around the box.
You can also remove comments that you no longer require.
Place the cursor on the cell with the comment you wish to remove.
From the Edit menu, select the Delete and Comments options.
To continue with this exercise, be sure to make a comment on the worksheet.
You can also view all the comments so that you can work with them you only need to change an option
From the Tools menu, select the Options option .
From the View section, select the Comment
& indicator option.
You'll need to return the option to None to hide the comments again.
You sometimes want to print the comments at the same page as the numbers. Excel can help you do that.
From the File menu, select the Page setup option.
Excel offers you three options to print your comments. The usual option is not to print the comments. You can also decide to print the comments at the bottom of the page or where they are on the worksheet.
From the Comments scrollbar, select As displayed on sheet option.
The comments will now print on the same page as you worksheet where they are located on the worksheet. But they will also hide the content of the cell that are below them. You can do a page preview before printing to make sure that they don't hide important numbers. You can always move the comments or change the size of the content tab.