 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Printing names
There is a View option to see formulae, so I can print the formulas. What about names? I can write code to list the names, put I'd rather print with names displayed. Is there an option to do this in Excel 97, 2000, 2002, or 2003? Nothing built into excel that I know. But if you're just looking (not printing), then change the window's zoom to 39% (or smaller) and you'll see the names of the ranges. I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp (Instead of writing my own.) > There is a View option to see formulae, so I can print the formulas. > [quoted text clipped - 3 lines] > displayed. > Is there an option to do this in Excel 97, 2000, 2002, or 2003?  SignatureDave Peterson > Nothing built into excel that I know. > > But if you're just looking (not printing), then change the window's zoom to 39% > (or smaller) and you'll see the names of the ranges. You have better eyes than I. Select a multiple cell contiguous range and name it. Then try it. You'll see it much clearer. The name for a single cell won't be shown--I can't see it anyway. > > Nothing built into excel that I know. > > [quoted text clipped - 3 lines] > > You have better eyes than I. SignatureDave Peterson Thanx. I'll have to settle for printing a list of the names. Insert | Name | Paste | Paste List (button) Not exactly what you wanted but... SignatureJim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Howard Kaikow" wrote in message There is a View option to see formulae, so I can print the formulas. What about names? I can write code to list the names, put I'd rather print with names displayed. Is there an option to do this in Excel 97, 2000, 2002, or 2003? > Insert | Name | Paste | Paste List (button) > Not exactly what you wanted but... I have code that creates a list of names, but Paste List does show the dead names (names with broken references). I'll change the macro to list the dead names. Hi Howard, I know you are not using 2007 but an FYI - In 2007 you can filter the "broken" names. Formulas, Name Manager, Filter, Names with Errors. (or Names without Errors). Then you can delete these in one step. If what you are trying to do is list the dead names as indicated below in <2007, then use the Paste List command and apply an Auto Filter, and go from there. Cheers, Shane Devenshire Microsoft Excel MVP >> Insert | Name | Paste | Paste List (button) >> Not exactly what you wanted but... > > I have code that creates a list of names, but Paste List does show the dead > names (names with broken references). > I'll change the macro to list the dead names. Hi Howard, I know you are not using 2007 but an FYI - In 2007 you can filter the "broken" names. Formulas, Name Manager, Filter, Names with Errors. (or Names without Errors). Then you can delete these in one step. If what you are trying to do is list the dead names as indicated below in <2007, then use the Paste List command and apply an Auto Filter, and go from there. Thanx. Actualyl, I was not interested in getting a list of the dead names, but turns out, that could be useful. I am programmatically creating a workbook, so there should not be any dead names, but I can use PasteList to make sure that I did not screw up.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.