Questions

How to enable comments option in Excel 2007

+
0 Votes
Locked

How to enable comments option in Excel 2007

Professor-X
Hi,

One of my user needs to print "comments" in Excel 2007 sheet. I went to Page Setup Option but "Comments" drop-down box is grayed out/disabled.

Please advise how to enable this option.

Much appreciated.
  • +
    0 Votes
    seanferd

    They need to be displayed in order to print.

    +
    0 Votes
    ThumbsUp2

    The following is from the HELP features of Excel 2003, but Excel 2007 should have similar places to turn things on/off.....

    Print comments

    Click the worksheet.

    If you want to print the comments in place on the worksheet, display the comments you want to print.

    To display an individual comment, right-click its cell and then click Show Comment on the shortcut menu. To display all comments, click Comments on the View menu. Move and resize any overlapping comments as necessary.

    On the File menu, click Page Setup, and then click the Sheet tab.

    Do one of the following:

    To print the comments where they appear on the worksheet, click As displayed on sheet in the Comments box.

    To print the comments at the end of the sheet, click At end of sheet in the Comments box.

    Click Print.

    +
    0 Votes
    Professor-X

    That solved the issue - Thanks mate

  • +
    0 Votes
    seanferd

    They need to be displayed in order to print.

    +
    0 Votes
    ThumbsUp2

    The following is from the HELP features of Excel 2003, but Excel 2007 should have similar places to turn things on/off.....

    Print comments

    Click the worksheet.

    If you want to print the comments in place on the worksheet, display the comments you want to print.

    To display an individual comment, right-click its cell and then click Show Comment on the shortcut menu. To display all comments, click Comments on the View menu. Move and resize any overlapping comments as necessary.

    On the File menu, click Page Setup, and then click the Sheet tab.

    Do one of the following:

    To print the comments where they appear on the worksheet, click As displayed on sheet in the Comments box.

    To print the comments at the end of the sheet, click At end of sheet in the Comments box.

    Click Print.

    +
    0 Votes
    Professor-X

    That solved the issue - Thanks mate