Print Excel Comments

First of all, what is an Excel comment?  It's basically a post-it note attached to any cell in the spreadsheet.


Open a spreadsheet, and in any cell hit your right-mouse button. Choose "Insert Comment" and you will see a little yellow post-it appear. Type anything in it and click away from it. A small red triangle is left in the cell. The triangle will not print, but if you float your mouse over it, you will see your note.

And sometimes it's nice to have all the notes printed. Here's how...

There are 2 options: "At end of sheet" or "As displayed on sheet".

Excel 2003:
Go to File, Page Setup, Sheet tab, and in the middle beside "Comments"
click the down arrow and choose an option. "At end of sheet" or
"As displayed on sheet".

Excel 2007:
On the Page Layout ribbon, in the Page Setup group, click the gray
arrow in the bottom right corner of the group.
On the Sheet tab, in the middle beside "Comments" click the down arrow
and choose an option. "At end of sheet" or "As displayed on sheet".

Happy Clicking!
Andy Lanning, Chief Nerd

Want more great tips? http://www.computersupersecrets.com/
Follow me on Twitter: http://twitter.com/TopNotchNerd