Saturday, May 21, 2011

Change the default display settings for comments in MS - Excel 2007

Change the default display settings for comments

  1. Click the Microsoft Office Button Button image, and then click Excel Options.
  1. In the Advanced category, under Display, do one of the following:
    • To hide both comments and indicators throughout the workbook, under For cells with comments, show, click No comments or indicators.
    • To show indicators but display comments only when you rest the pointer over their cells, under For cells with comments, show, click Indicators only, and comments on hover.
    • To display both comments and indicators at all times, under For cells with comments, show, click Comments and indicators.

Display or hide comments on the worksheet

  1. Click the cell or cells that contain a comment indicator.
  2. On the Review tab, in the Comments group, click Show/Hide Comment.
Excel Ribbon Image
 Tip   You can also right-click the cell that contains the comment, and then click Show/Hide Comments.

Display or hide all comments on the worksheet

  • On the Review tab, in the Comments group, click Show All Comments.
Excel Ribbon Image
 Tip   Clicking Show All Comments again will hide all comments on the

0 comments:

Post a Comment

Copyright © 2015 Accounting & Taxation All Right Reserved
Subscribe by Email Get Free Updates
Don't Forget To Join US Our Community
×
blogger