Topics

Feb 5, 2011

Review comments in a workbook in Excel 2007

If your workbook has single or many sheet(s) with comments added to cells and you need to know the comments present in the workbook. Looking for the small red triangle in a cell that indicates comment in the entire worksheet and in the entire workbook might be a painful job. Fortunately Microsoft Excel provides a way to view all the comments at the same time or navigate through a single comment at a time.

To review all the comments in Excel 2007, perform the following:
1. Click Review tab.
2. Click Show All Comments to view all the comments.
To view only one comment at a time, perform the following:
1. Click Review tab.
2. Click Previous or Next to view the previous comment or the next comment.
Once you had reached the last comment, Microsoft Excel will notify you in a OK Cancel dialog box saying “Microsoft Excel reached the end of the workbook. Do you want to continue reviewing from the beginning of the workbook?

0 comments:

Post a Comment