Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Print comments
 
  1. Click the worksheet.
  2. 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.

    ShowHow?

    1. Click the border of the comment box so that handles (sizing handle: One of the small circles or squares that appears at the corners and sides of a selected object. You drag these handles to change the size of the object.) appear:

      Worksheet comment with sizing handles

    2. Do one or more of the following:

      To move the comment, drag the border of the comment box.

      To change the size, drag the handles on the sides and corners of the comment box.

  3. On the File menu, click Page Setup, and then click the Sheet tab.
  4. 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.

  5. Click Print.
advertisement