How to get a cell name to appear in comment printout

M

Mark

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?
 
N

Nick Hodge

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
[email protected]
 
Top