ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print with comment in worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/134168-print-comment-worksheet.html)

tikchye_oldLearner57

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

chad

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


tikchye_oldLearner57

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


ChatAngel

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


JR Hester

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


Doug

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



All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com