Mastersball Fantasy Forum

I'm trying to get the worksheet set up, but there is no Insert->Names selection in Excel 2007.

Anyone know where I need to go?

From the Formulas menu --> Go to Named Cells panel --> Click Name a Range dropdown --> Select Name a Range

Actually, the 2007 version of Excel has a Name Manager function (something LOOONG overdue) on it's little ribbon. Click Formulas, then click Name Manager (in the Defined Names portion of the ribbon). A window will now open telling you alll the range names in the current workbook, their current values and the current boundaries of the range name without having to go on a search expedition. It also allows you to add, delete or modify a range name without having to continually open and close the dialog boxes. A nice enhancement.

Thanks. That was way easier than in prior years. It let me change the name without having to go through the step of deleting the old one.