Print Your Excel Comments.

Posted on May 23, 2008 
Filed Under Excel Tips & Tricks

The last Tip and Trick for this week is an Excel Tip and Trick. Today I want to show you something cool/useful that has to do with the comments in excel. We already know that using comments in MS Excel can be really helpful.

 

Normally you only make the comments in your spreadsheet and you don’t print them. Well you can but the default setting in Excel is that you don’t print them. This is also the case when you right click on the cell and select Show Comment. This way your comment stays open and can you continue to work in your spreadsheet. If you want to print your comments you’ll need to change some settings.

 

Print-your-excel-comments-pic1

 

Follow these steps to print your comments in Microsoft Excel.

 

  • First you’ll need to go to the review tab.
  • And select Show all Comments

 

Print-your-excel-comments-pic2

 

  • Select the Page Layout tab
  • And in the Page Setup group, click the dialog box launcher next to Page Setup.

 

Print-your-excel-comments-pic3

 

  • And on the Sheet tab you can select if and how you want them printed.
  • I selected for this example Comments: As displayed on sheet.

 

Print-your-excel-comments-pic4

 

  • Now click OK and this is how my printscreen now looks like.

 

Print-your-excel-comments-pic5

 

So that’s it for today and I hope you liked this Excel tutorial. Next week will be another Excel week with only formula’s like we did a couple of months ago. So if you want to learn some useful Excel formulas, be sure to check back with us coming Monday. Have a great weekend!!

 

 

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

One Response to “Print Your Excel Comments.”

  1. Kathryn on August 8th, 2008 12:08 pm

    This is an awesome website.
    I have Vista home edition which after a year I have finally gotten used to.
    Now in a new job using the professional version and always struggling to find tips and shortcuts. This site makes it so easy for me to find out how to do things I now find I can’t do compared to older versions of windows.
    Thanks will be using this more often!

Leave a Reply