Printing Comments

[smoszkowicz]

I have created many, very detailed comments in my spread
sheet. When I go and print the spreadsheet the comments
are printed on their own page. This is fine. What I need
to change is that each comment is referenced by the cell
number. It is printing like

Cell: A5
Comment: bla bla

There is no way for a person to reference a cell number by
looking at the printout. How do I change the format of
the printed comment to show the contents of the cell that
the comment is actually associated with. I do not want
the print out to show Cell:A5. I want it to display
Cell: "Unit Cost" (Because that is what is typed in that
cell)
Comment: Bla Bla

 

[Jason Morin]

Someone could reference back to the cell if you print the
worksheet with the row and column headings. File > Page
SetUp > Sheet tab and check the box that reads "Row and
column headings".

HTH
Jason
Atlanta, GA

 

[Dave Peterson]

Debra Dalgleish has some alternatives at:
http://www.contextures.com/xlcomments03.html

(one as a new worksheet, one using MSWord).

You could modify either to include anything you wanted.