You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/. This post informs you about Name Manager, a free utility that helps you manage defined names in your workbooks.
If you need a free utility to manage defined names in your workbooks, this one is a must-have. List all names in your active workbook. Filter them using 13 filters including "With external references," "With errors," "Hidden," and "Visible." Show only names that contain a substring. Show only names unused in worksheet cells. Edit them in a simple dialog box or edit them in a list and update all names at once. Supports the 2007 Office system.
To download Name Manager, visit www.jkp-ads.com/officemarketplacenm-en.asp.
For information about how to define names, see Define and use names in formulas.
Comments: (3) Collapse
At last well deserved recognition for a add-in
a) Which I use every single day
b) Which Microsoft did not have the wisdom to simply buy and use it in Excel
c) Which they tried to replicate in 2007 a ended up with a pathetic version compared to the "real" name manager
d) Which finally made it in Power Tips on this blog.
For the Next power tip you can consider linking to the "Real" Ribbon Customiser from Andy Pope... and may be the UI astronauts can get inspired from it and use it in 2010...The current customization option is simply inadequate.
Please note that I developed this tool together with Charles Williams of www.decisionmodels.com.
Hi everyone,
I have a licensed version of FastExcel containing NM and I simply can't do without it.
Regards
Kanwaljit
Comments: (loading) Collapse