Here's the answer to last week's challenge on printing Excel comments, along with a new question to test your PowerPoint skills.
There are many reasons you might want to export the text in a PowerPoint presentation. For instance, you might need to repurpose the text in other documents and reports. Or you might want to publish the text in note form for your audience. So this week’s Office Challenge asks: How do you export PowerPoint text?
Last week we asked…
“How do you print Excel comments?” This question really has more than one answer because you can print comments in place with the worksheet data or at the end of the worksheet:
To print a worksheet with the data in place, choose Page Setup from the File menu, click the Sheet tab, and click the As Displayed On Sheet options from the Comments control.
To print comments together, following the data, choose the At End Of Sheet option from the Comments box.
Excel further complicates things because it will print only those comments you show in the worksheet. Excel will not print any comments you hide. To print a comment that's hidden, display it first by right-clicking the commented cell and choosing Show Comment from the resulting shortcut menu. Unfortunately, I don’t know of any way to unhide multiple comments.
Thank you to everyone who responded to the challenge. Many of you know the basics on printing Excel comments. Thanks to michael.cutler@ for his additional tip for printing some, but not all of your sheets; that was a great tip! And pgurney@ went a bit further with the tip by mentioning the hidden comment limitation I mentioned above.