print comments using cell contents, not cell#

D

dickenswick

I would like to see a printout of my comments using the contents of the cells
I'm printing, not "Cell: c8" for example, but "Cell: 478232".
 
D

David McRitchie

D

dickenswick

478232 was just an example of some data that i'm using in a cell . my boss
would like to see a printout of comments that says this number (i mean the
contents of the cell) follwed by the comments instead of the cell number
followed by the comments, because this number means something to him and he
doens't want to have to reference the table to understand which piece of data
the comments are discussing.

David McRitchie said:
Huh? How do come by 478232 as a cell reference number

or did you mean C8: 478232

File, Page Setup, Sheets,
[x] Row and Column Headings
Comments: At End of Sheet

If you want to tailor your own printout of cell comments see
http://www.mvps.org/dmcritchie/excel/ccomment.htm#printsastext

Macro to populate another sheet with comments by column (#printcommentsbycolumn)
http://www.mvps.org/dmcritchie/excel/ccomment.htm#printcommentsbycolumn

"dickenswick" wrote ...
I would like to see a printout of my comments using the contents of the cells
I'm printing, not "Cell: c8" for example, but "Cell: 478232".
Click to expand...
Click to expand...
 
Top