Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 77
Default print with comment in worksheet

hi community

I displayed out my comments in my worksheet and wanted to do a print out
with the comment as well, but when I do a print preview, I only can see the
worksheet data but no comments can be seen ???

Note:
I already activated the comments/indicator at the option menu

is it possible to have comment be printed along with worksheet data ?

any help much appreciated :)

thanks community
--
oldLearner57
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 273
Default print with comment in worksheet

Go to page setup on the sheet tab. Under Print, and comments, select "as
displayed on sheet."

Hope this helps,
Chad

"tikchye_oldLearner57" wrote:

hi community

I displayed out my comments in my worksheet and wanted to do a print out
with the comment as well, but when I do a print preview, I only can see the
worksheet data but no comments can be seen ???

Note:
I already activated the comments/indicator at the option menu

is it possible to have comment be printed along with worksheet data ?

any help much appreciated :)

thanks community
--
oldLearner57

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 77
Default print with comment in worksheet

yes! indeed it helps me
:)
thanks chad
also to community
--
oldLearner57


"Chad" wrote:

Go to page setup on the sheet tab. Under Print, and comments, select "as
displayed on sheet."

Hope this helps,
Chad

"tikchye_oldLearner57" wrote:

hi community

I displayed out my comments in my worksheet and wanted to do a print out
with the comment as well, but when I do a print preview, I only can see the
worksheet data but no comments can be seen ???

Note:
I already activated the comments/indicator at the option menu

is it possible to have comment be printed along with worksheet data ?

any help much appreciated :)

thanks community
--
oldLearner57

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default print with comment in worksheet

Will doing this make the comment indicator print in the cell? I don't need
the comment to print out - just the (red) indicator. Is this possible? I did
see that someone mentioned activating the "comments/indicator at the option
menu" but my option menu doesn't give that as an option - only layout and
print quality. I also already have "as displayed on sheet" checked off but
nothing happened. I'm using Excel 2003 SP2 (this is at my job - I don't own
Office at home).

Thanks for any help you can send my way!
--
ChatAngel


"Chad" wrote:

Go to page setup on the sheet tab. Under Print, and comments, select "as
displayed on sheet."

Hope this helps,
Chad

"tikchye_oldLearner57" wrote:

hi community

I displayed out my comments in my worksheet and wanted to do a print out
with the comment as well, but when I do a print preview, I only can see the
worksheet data but no comments can be seen ???

Note:
I already activated the comments/indicator at the option menu

is it possible to have comment be printed along with worksheet data ?

any help much appreciated :)

thanks community
--
oldLearner57

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 170
Default print with comment in worksheet

Your question helped me. I had already set the Comments as displayed option
in Filepage setupsheet; but had overlooked the ToolsOptionsviewcomments
and indicators setting. Thsi thread put me on the right track.

"tikchye_oldLearner57" wrote:

hi community

I displayed out my comments in my worksheet and wanted to do a print out
with the comment as well, but when I do a print preview, I only can see the
worksheet data but no comments can be seen ???

Note:
I already activated the comments/indicator at the option menu

is it possible to have comment be printed along with worksheet data ?

any help much appreciated :)

thanks community
--
oldLearner57



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 460
Default print with comment in worksheet

Is there a way to do this in Excel 07?

DOUG in KS

"JR Hester" wrote:

Your question helped me. I had already set the Comments as displayed option
in Filepage setupsheet; but had overlooked the ToolsOptionsviewcomments
and indicators setting. Thsi thread put me on the right track.

"tikchye_oldLearner57" wrote:

hi community

I displayed out my comments in my worksheet and wanted to do a print out
with the comment as well, but when I do a print preview, I only can see the
worksheet data but no comments can be seen ???

Note:
I already activated the comments/indicator at the option menu

is it possible to have comment be printed along with worksheet data ?

any help much appreciated :)

thanks community
--
oldLearner57

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
print renamed cell with comment? Tech_babe Excel Discussion (Misc queries) 0 August 25th 06 03:26 PM
Can you print indicators when inserting a comment? Carmen Excel Worksheet Functions 2 April 14th 06 05:08 PM
Print Excel Comment in the same sheet Fuad Excel Discussion (Misc queries) 0 November 23rd 05 07:50 AM
Print Excel Comment Indicators SidBord Excel Discussion (Misc queries) 3 March 24th 05 02:41 AM
HOW DO I PRINT THE ENTIRE COMMENT rhw Excel Discussion (Misc queries) 2 December 29th 04 07:15 PM


All times are GMT +1. The time now is 09:45 PM.

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

About Us

"It's about Microsoft Excel"