How to get a cell name to appear in comment printout

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have named a cell eg 'Sales' which has a comment attached to it. However
when printing the comment at the end of a sheet. The comment is referred to
in R1C1 style eg 'A3' instead of as 'sales'. How do I get a worksheet to
printout with comments at the bottom referenced as the name of each cell
rather than R1C1?
 
Mark

You can't through the UI

For info the style A3 is 'A1' format not R1C1 which for A3 would be R3C1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import Comments 3
Listing Comments 2
comments in a cell 6
VBA insert comment only when cell in a range changes first time 5
Custom print comments in Excel 2007 1
list sheet comments 4
Extract comments? 2
Word to Excel: Export comments with text and line number 0

Back
Top