Cell identity when printing comments on separate page

[Carl001]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel When printing comments at end of page, it identifies the cell by letters and numbers. (i.e. Cell: AA33) Afterward the comment is shown for that cell.

Question: Instead of the cell identity being shown this way, is it possible ithe cell can also be identified by its X axis header for that column with the y access header for that Row.

Thank for your assistance.

Carl

 

[CyberTaz]

Sorry Carl, but I'm not clear on what you're asking for... In 'MySpeak'
the AA in your example _is_ the "X axis header for that column" & 33 _is_
the "y access header for that row". The combination of those 2 references
form the cell's reference. That, of course, identifies the cell's position
on the grid... In this example, Column AA, Row 33.

What, specifically, would you want to have used in place of AA & 33?

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Carl001]

ok. If you have a column title and row title and you are printing comments at the end of the document. Can the column and row titles of your table identify the cell also.

For example:
currently
Cell: AB33
Comment: Mislabeled test

Is it possible:
Cell: AB33 Doe, Carl PIE
Comment: Mislabeled test

These are Row and column titles for this cell in the table.

Thanks,
Carl

 

[CyberTaz]

AFAIK there is no way to modify the Comment output page. There are a number
of options in versions of Excel that support VBA but they'll do no good in
2008. I tend to doubt that there are Apple Script alternatives but am not
sure. Perhaps someone else will be able to shed more light on that.

The only alternative I am aware of would be to reposition each Comment
balloon on the sheet & using the Page Setup option for 'As displayed on
sheet'. Depending on the amount of content, the sheet layout & the number of
comments that may not be a practical or preferable solution.

Regards |:>)
Bob Jones
[MVP] Office:Mac