Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I print comments individually?

I know that I can print all of them at the end of the document or as
displayed on the sheet. I would like to print them individually without
having to copy and paste each one in a word document. Also, I do not
understand programming. I am fairly proficient with the standard features.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default How do I print comments individually?

To print just the comments:
Choose FilePage Setup, and on the Sheet tab, from the Comments
dropdown, choose At End of Sheet.
Click Print Preview, to see which page the comments start on
Click Print, and set the print range from the comment start page, to the
last page.
Click OK.

Or, there's code here that you can use to copy the comments to another
worksheet, and then print that sheet:

http://www.contextures.com/xlcomments03.html

There are instructions here for copying code to a regular module:
http://www.contextures.com/xlvba01.html

After you do that, you could choose ToolsMacroMacros, select a macro,
and click Run.

SNC MHORON wrote:
I know that I can print all of them at the end of the document or as
displayed on the sheet. I would like to print them individually without
having to copy and paste each one in a word document. Also, I do not
understand programming. I am fairly proficient with the standard features.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comments - print at end of sheet Dal_Reta Excel Discussion (Misc queries) 2 August 21st 07 03:28 PM
how do I print cell comments? Dave F Excel Discussion (Misc queries) 2 October 10th 06 02:24 PM
How do I print comments on a chart? Tom Z. Charts and Charting in Excel 11 March 16th 06 08:44 PM
Listing consecutive days without inputting each one individually jcrouse Charts and Charting in Excel 1 February 8th 05 02:18 PM
Concatenate cells without specifying/writing cell address individually Hari Excel Discussion (Misc queries) 4 January 3rd 05 06:05 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"