Jump to content


Photo

Printing Named Cells

Defined names Printing defined names

  • Please log in to reply
1 reply to this topic

#1 Mike Loomis

Mike Loomis

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 02 February 2018 - 01:54 AM

I know how to define a name for a cell. I also know how to print comments at the end of an Excel printout. How can I get the defined name of the cell to print with the comments associated with that cell instead of B2 for example?



#2 Mike

Mike

    Advanced Member

  • Administrators
  • 190 posts

Posted 03 February 2018 - 02:04 PM

Hi Mike,

 

Unfortunately I don't think that cell names can be printed. They can, however, be viewed using the Name Manager. You can see this done in Expert Skills Session 4: Using Names and the Formula Auditing Tools.

 

Please feel free to reply if you need any more help with this.


Mike Smart is the author of ten world best-selling Excel books. The books are available in printed form for for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Mike has also recorded over 850 video lessons (that you can watch online) for Excel 2007, Excel 2010 and Excel 2013.
Mike Smart is also part of the team that answers questions posted on the ExcelCentral.com forums.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users