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)
 
Back
Top