Managing Comments

Besides simply adding and viewing comments one at a time, Excel includes a toolbar that you can use to manage your comments. This toolbar is called, appropriately enough, the Reviewing toolbar. If you have quite a few comments in your worksheet, this can be a great help.

To display the Reviewing toolbar, simply choose Comments from the View menu. You can also choose Toolbars from the View menu, and then choose Reviewing from the list of available toolbars.

Once the Reviewing toolbar is visible, you can continue using your worksheet as you normally would. However, the buttons on the toolbar make it very easy to work with the comments. For instance, you can add a comment to a cell by clicking your mouse on the New Comment tool.

Perhaps the most helpful tools on the Toolbar are the Previous Comment and Next Comment tools. These allow you to work strictly with comments and jump from one to the other. As you click your mouse on one of these tools, Excel highlights a comment. The New Comment tool changes to Edit Comment, and you can use the Hide Comment tool to dismiss the comment and the Delete Comment tool to permanently remove it.

When you are done working with comments, you will want to click on the Hide All Comments tool and then close the Reviewing toolbar.