Printing Excel Comments

[Steve]

I have a spreadsheet that contains numerous comments. Using the page set-up I
can tell it to print the comment either IN the spreadsheet or AFTER the
spreadsheet. However, when I choose the IN spreadsheet, the comments do not
appear, but when I choose after the spreadsheet, the comments appear and
print out. Why would they NOT appear and print in the spreadsheet? Would
having too many comments prohibit them from showing ont he page?

[David McRitchie]

Hi Steve,
Are the comments displayed on the sheet before printing.
file, page setup, sheet, print comments as displayed, OK
tools, options, View, Display indicator and comment

-- don't forget the OK

To reverse the above reenter different options.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Steve" <[email protected]> wrote in message news:[email protected]...
> I have a spreadsheet that contains numerous comments. Using the page set-up I
> can tell it to print the comment either IN the spreadsheet or AFTER the
> spreadsheet. However, when I choose the IN spreadsheet, the comments do not
> appear, but when I choose after the spreadsheet, the comments appear and
> print out. Why would they NOT appear and print in the spreadsheet? Would
> having too many comments prohibit them from showing ont he page?

[Steve]

Yes they are visible during mouse-over, but they do not print out.

"David McRitchie" wrote:

> Hi Steve,
> Are the comments displayed on the sheet before printing.
> file, page setup, sheet, print comments as displayed, OK
> tools, options, View, Display indicator and comment
>
> -- don't forget the OK
>
> To reverse the above reenter different options.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Steve" <[email protected]> wrote in message news:[email protected]...
> > I have a spreadsheet that contains numerous comments. Using the page set-up I
> > can tell it to print the comment either IN the spreadsheet or AFTER the
> > spreadsheet. However, when I choose the IN spreadsheet, the comments do not
> > appear, but when I choose after the spreadsheet, the comments appear and
> > print out. Why would they NOT appear and print in the spreadsheet? Would
> > having too many comments prohibit them from showing ont he page?
>
>
>

[David McRitchie]

Mouse over is not the same as Display indicator and comment.
which is the only way you are going to have them print within the spreadsheet.

If you don't like the ways the comments print at the end of the spreadsheet,
you have some other choices by using macros or addins -- see my page
Cell Comments
http://www.mvps.org/dmcritchie/excel/ccomment.htm
basically you might also want to see
cell address, text displayed, value, formula, format
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Steve" <[email protected]> wrote in message news:[email protected]...
> Yes they are visible during mouse-over, but they do not print out.
>
> "David McRitchie" wrote:
>
> > Hi Steve,
> > Are the comments displayed on the sheet before printing.
> > file, page setup, sheet, print comments as displayed, OK
> > tools, options, View, Display indicator and comment
> >
> > -- don't forget the OK
> >
> > To reverse the above reenter different options.
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Steve" <[email protected]> wrote in message news:[email protected]...
> > > I have a spreadsheet that contains numerous comments. Using the page set-up I
> > > can tell it to print the comment either IN the spreadsheet or AFTER the
> > > spreadsheet. However, when I choose the IN spreadsheet, the comments do not
> > > appear, but when I choose after the spreadsheet, the comments appear and
> > > print out. Why would they NOT appear and print in the spreadsheet? Would
> > > having too many comments prohibit them from showing ont he page?
> >
> >
> >