how to print reference label name in excel for comments?

[Guest]

I have chosen to print comments at the bottom of my spreadsheet the problems
is it only gives the cell reference number. If I am looking at a printed
version I would not know what cell it is refering to. I then labeled
(reference) each cell but it still does not print out the name of the cell.
How can I print out the label name oppose to $b$3$?

 

[Guest]

Go to Print, Page Setup, Sheet, and select (under print), row and column
headings. This will print out the headings just as you see them on your
monitor.

HTH
Carole O

 

[Debra Dalgleish]

You can use programming to copy the comments, with the cell name, to a
different worksheet. There are instructions here:

http://www.contextures.com/xlcomments03.html#CopyToSheet

There are instructions here for copying the code to your workbook:

http://www.contextures.com/xlvba01.html#Regular

To run a macro, choose Tools>Macro>Macros
Select a macro, click Run