A good way to organize and protect Named Ranges in Excel is to place all of them on a separate  worksheet. This sheet can then be protected and also hidden from view (but the named ranges still work)
An added bonus is the ability to copy this sheet to a new workbook so all your named ranges are ready for use. Excel training Toronto, Ontario

Bert Twomey
Excel 2010/2007/2003 trainer
Mississauga, Toronto, Ontario

Excel training Toronto Mississauga

new functions such AverageIFS are in Excel 2010, this means you can find the average of cells based on multiple criteria - very useful Excel function to save time. click on Excel training Toronto Mississauga, for more info re Excel training

Bert Twomey
Excel trainer