Printing names

H

Howard Kaikow

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

Dave 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.

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.)
 
J

Jim Cone

Insert | Name | Paste | Paste List (button)
Not exactly what you wanted but...
--
Jim 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?
 
H

Howard Kaikow

Jim Cone said:
Insert | Name | Paste | Paste List (button)
Not exactly what you wanted but...
Click to expand...

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.
 
H

Howard Kaikow

Dave Peterson said:
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.
Click to expand...

You have better eyes than I.
 
D

Dave Peterson

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.
 
S

Shane Devenshire

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
 
Top