1-866-245-5224 sales@keystonelearning.com

Excel 2007: Viewing & Printing Comments

Excel 2007: Viewing & Printing Comments

Once your comments have been entered into your worksheet file, it’s nice to be able to review them and print them once in a while.

Viewing Comments

I’m sure you’ve already figured out how to hover your mouse over the top of the red triangle in the upper-right corner of any cell that contains a comment, but in this section, we’ll focus on additional view options. With Comments, you have the option of viewing each comment individually or all comments at one time.

Viewing One Comment Using the Ribbon

     
  1. Select the cell that contains the comment you want to edit
     
  2.  
  3. Click the Show/Hide Comment command in the Comments group on the Review tab
     

Viewing All Comments Using the Ribbon

     
  1. Select the cell that contains the comment you want to edit
     
  2.  
  3. Click the Show All Comments command in the Comments group on the Review tab
     

Viewing All Comments Using the Shortcut Menu

     
  1. Right-click the cell that will contain the comment
     
  2.  
  3. Choose Show/Hide Comments from the Shortcut Menu
     

Printing Comments

In addition to viewing comments on the screen, you can also print them. But, you’ll need to decide where you want them to print. In the past few versions of Excel, the option of printing comments has only been made available as a separate page at the end of your print job. However, with Excel 2007, you can also choose to print the comments with your worksheet as it appears on your screen.

Printing Comments at the End

By default, your print setup is designed to never print your comments. But, that’s a quick fix in the Page Setup dialog box.

     
  1. Click the Page Setup Dialog Box Launcher (  ) located on the lower-right corner of the Page Setup Group on the Page Layout tab.
     
  2.  
  3. Click the Sheet tab
     

    3.       Change the Comments drop-down to read “At end of sheet

    4.       Click OK

    5.       Print your file as usual

Printing Comments In Place

     
  1. Click the Page Setup Dialog Box Launcher ( ) located on the lower-right corner of the Page Setup Group on the Page Layout tab.
     
  2.  
  3. Click the Sheet tab
     

    3.       Change the Comments drop-down to read “At displayed on sheet

    4.       Click OK

    5.       Print your file as usual