Name Manager in Excel 2007

I thought I would do a series on some of the features in Excel 2007.

One of the annoying things in old Excel was the maintenance of Names. Excel 2007 has made it a lot nicer with the Name Manager.

Here is a part of the Formulas tab with the Name Manager highlighted.



Click this and the following is displayed. You can see clearly which name is a Workbook scope and which is a Worksheet scope.



Click New to add a new name... In the Scope section, you have the choice of Workbook or the individual sheets in the Workbook. Easy!



Also you can use Name a Range to highlight a range and then apply a name to it or Apply Names to apply an existing name to a highlighted range.



If you wish to add a formula with a name in it, choose Use In Formula.



One last thing possible is for Excel to automatically create names based on the content on the cells using Create From Selection. Highlight a desired section, and Excel gives you options for which part of the selection you would like the Name to be created from. In this case, Excel created 3 Workbook scope names for me, Alpha, Bravo and Charlie.