Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named ranges in Excel 2007
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named ranges in Excel 2007
Insert, Name, Create is "Create from Selection" in the Defined Names group
on the Formulas tab. -- Jim wrote in message ups.com... | 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. | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named ranges in Excel 2007
Ctrl-Shift-F3 is a shortcut that works in all versions, btw.
-- Jim wrote in message ups.com... | 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. | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I name worksheets in Excel according to named ranges? | Excel Worksheet Functions | |||
Importing Excel named ranges using MS Query | Excel Discussion (Misc queries) | |||
Excel 2007 Beta-Named Ranges | Excel Discussion (Misc queries) | |||
Accessing named ranges in Excel from VBA | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |