O'Reilly logo

Excel 2010: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding Comments

Comments are the simplest of Excel's collaboration features. Excel displays comments in a floating yellow box that points to a single cell (as shown in Figure 25-8). Place whatever descriptive text you want inside the comment box. For example, you can use comments to flag an error, raise a question, make a suggestion, or praise a particularly brilliant formula.

This worksheet includes a single comment attached to cell B3. You can clearly see the arrow that connects the floating comment box to cell B3. Additionally, a tiny red triangle in the top-right corner of the cell indicates it has an attached comment.

Figure 25-8. This worksheet includes a single comment attached to cell B3. You can clearly see the arrow that connects the floating comment box to cell B3. Additionally, a tiny red triangle in the top-right corner of the cell indicates it has an attached comment.

The beauty of comments is that you're free to include as much information as you want without modifying the worksheet data. For that reason, comments work perfectly when you're sending a workbook out for review. An employee can send an expense report to a manager, and the manager can add feedback using comments without altering the original information. Once the manager sends the workbook back, the employee can then decide whether to heed the comments and make some changes, keep the comments for later consideration, or just remove them altogether.

Inserting a Comment

Every workbook can include thousands of comments. The only limitation is that each individual cell can have only one attached comment.

To create a new comment, just follow these steps:

  1. Move to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required