Weekly Computer Tip # 142
3 February 2006

Print a document or worksheet with comments showing (Microsoft Word and Excel)

This week's tip is inspired by Joy Butler who emailed asking "How do I get comments inserted into a document to print on the page that the comments referred to and not at the end of the document?" Good one! And one I often get asked for Excel as well.

Here's how (in Word 2003)

1. From the File menu, select Print.
2. In the Print what list, click Document showing markup.
3. Click OK.

Here's how (in Word 2000)

1. From the File menu, select Print.
2. Click the Options button.
3. In the Include with document area of the dialog box tick the Comments check box.
4. Click OK twice.

Here's how (in Excel)

1. From the File menu, select Page Setup.
2. Select the Sheet tab.
3. Select the At the end of sheet option from the Comments drop-down list in the Print area of the dialog box.
4. Click OK.

The comments will be printed on a separate page at the end of the document. In Excel, you might also want to tick the Row and column headings check box, so that, apart from the comments, the cell references in which the comments "live" are printed.

Finally, I should apologise for a blatant bit of bragging, but what's the point of having your own weekly audience if you cannot stick in some mildly important news about yourself? So here we go ... BBC Radio Cambridgeshire has asked me to "appear" on the Sue Dougan show. They were looking for a computer expert and that expert will be me. (Wooha!) In case you're interested to tune in, I'll be riding the radio waves between 2 and 3 on Friday 24 February.

Until next week.

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer