Named Ranges are set of selected cells in Microsoft office excel 2007 which can be identified by a unique name. These serve a good purpose when you want to refer across sheets or even when you create protection of parts of excel files for different users.

Now lets assume you have a very large excel files with around 10 sheets and each sheet has around 7 named ranges. So when you come to handle each of them individually it becomes very difficult and tedious. Last few weeks I had been working in similar scenario and was surprised how I missed the feature called as Name Manager which is present in Excel by default.

This not only helps you to find all the named ranges in the excel file across sheets but also helps you to manage ( create, delete and update ) all of them at one place. You can even set the scope of each of them.

On top of this you get the power of filtering them and also find how many of them got errors while creating them. So go ahead and try Name manager and make you life more productive.