Excel 2007 : how to use the named range feature in Excel 2007

I have several questions, the first of which concerns the new version of excel which is why I posted in the 'Excel 2007 Help'.

How do I delete a named range if I decide that I no longer need it and don't want it floating around in Excel 2007?

Also, I am creating a form that has several control boxes which are linked to ranges on specific sheets of the workbook using the named ranges. If I were to add on to the end of those lists as more information became available, how would I update the named range automatically so that the new items would be included in the combobox on my form?

Hello Glenver,

To modify/add/remove defined names in Excel 2007, click on the Formulas ribbon, then click 'Name Manager'. There you'll see all defined names and can do with them as you like.

As for dynamic named ranges, to include new rows of data as you enter them below the current list, see this link: http://www.cpearson.com/excel/named.htm

Chip's site does a good job explaining named ranges and how to work with them.