Named ranges in Excel 2007

[argniw]

In Excel 2003 and earlier, if you want to rewrite over a set of named
ranges, for example, you would highlight the data and headers and go
to Insert ->Name->Create and pick the appropriate choice. If the names
already existed, the system would prompt you to overwrite.

I have not found a way to replicate this in the new user interface in
Excel 2007? Please advise.

 

[Jim Rech]

Insert, Name, Create is "Create from Selection" in the Defined Names group
on the Formulas tab.

--
Jim
| In Excel 2003 and earlier, if you want to rewrite over a set of named
| ranges, for example, you would highlight the data and headers and go
| to Insert ->Name->Create and pick the appropriate choice. If the names
| already existed, the system would prompt you to overwrite.
|
| I have not found a way to replicate this in the new user interface in
| Excel 2007? Please advise.
|

 

[Jim Rech]

Ctrl-Shift-F3 is a shortcut that works in all versions, btw.

--
Jim
| In Excel 2003 and earlier, if you want to rewrite over a set of named
| ranges, for example, you would highlight the data and headers and go
| to Insert ->Name->Create and pick the appropriate choice. If the names
| already existed, the system would prompt you to overwrite.
|
| I have not found a way to replicate this in the new user interface in
| Excel 2007? Please advise.
|