View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stanley
 
Posts: n/a
Default Display Comments on Each Page

I have a spreadsheet that I need to add comments to. Currently the method to
leave comments about a particular cell is to use a textbox or shape with text
in it. As you can imagine this can clutter the spreadsheet.

I know you can have the comments print at the bottom of the sheet, however,
I need the comments to print at the bottom of the sheet that that cell is
printed on. So if I have a 3 page printout the comments on page 1 should show
at the bottom of page 1 not on page 4 all by themselves. I also need the
comments or would like to have the comments handle carriage returns. I know
how to pull out the comments for a range however I have run into the issue of
formating them. Anyone have any examples or ideas that can help me? Thank you.