Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Review Tab

proofing - language - comments - changes

EXCEL 2010 REVIEW COMMENTS RIBBON

Comments

EXCEL 2010 REVIEW COMMENTS GROUP

 You can add a cell comment, an electronic version of a sticky note, to any cell in an Excel 2010 worksheet. Comments allow those reviewing a worksheet to provide instruction, entering thoughts, questions and specifics about the type of information the user should enter into the cells.

Let’s start by adding a new comment to a cell. On the Review tab, in the Comments group, click the New Comment button. A yellow comment box with your name and a blinking cursor appears. With the comment box open, you can drag the lower-right corner of the comment box to make it larger.

EXCEL 2010 REVIEW COMMENTS NEW COMMENT



Type your comment and then click outside of the cell.

Excel will display a red triangle in the upper-right corner of the commented cell.

You can point to a cell containing a red triangle to display the comment text.

You can edit an existing comment by selecting the cell with the comment. On the Review tab in the Comments group, click the Edit Comment button. The comment box displays and allows you to make any desired changes. Click outside of the comment box when you are finished with your edits.

EXCEL 2010 REVIEW COMMENTS EDIT COMMENT




To move from comment to comment within your worksheet select the Previous or Next buttons in the Comments group (as shown in the image to the left). Excel displays another comment.

Click on a cell that contains a comment. Click the Show/Hide Comment button in the Comments group of the Review tab. Excel keeps the current comment displayed on the screen until you click this button again. When this button is not selected, you can only view the comment by hovering over the cell. As soon as your mouse leaves the cell, the comment is hidden.

EXCEL 2010 REVIEW COMMENTS SHOW ALL



Click the Show All Comments button in the Comments group of the Review tab. Excel displays all comment boxes on the current worksheet (as shown in the image to the right). Click the Show All Comments button again to turn off the comment display.

To delete a comment, select the cell containing a comment and then click the Delete button in the Comments group of the Review tab.

The Show Ink command in the Comments group is only available on Tablet PCs, with a specific version of Windows for Tablets. It enables the user to write notes with a stylus pen onto the screen, and it will be saved with the file as a hand-written note.

Next Tutorial


This concludes the Comments tab tutorial.
Click next to continue to the Changes tutorial.