Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel {2007} Named Ranges: Renaming, Deleting etc...
I have a range in a worksheet which I named "Prices" using the "Name
Box" (The box that shows the Cell reference [A1 etc...]) I am trying to select a different range on another Worksheet and call it "Prices", but whenever I type in the word "Prices", the original "Prices" range is selected on the other worksheet! So, my question is - How do you remove the name from a range, so that the range no longer has a name! I am sure I knew how to do this, but I cannot for the life of me remember! I have googled, and used the Help file, but all I get is information about clearing the contents etc of a range! This make sense? Thanks. Demon. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel {2007} Named Ranges: Renaming, Deleting etc...
"DemonTraitor" wrote in message
... I have a range in a worksheet which I named "Prices" using the "Name Box" (The box that shows the Cell reference [A1 etc...]) I am trying to select a different range on another Worksheet and call it "Prices", but whenever I type in the word "Prices", the original "Prices" range is selected on the other worksheet! So, my question is - How do you remove the name from a range, so that the range no longer has a name! I am sure I knew how to do this, but I cannot for the life of me remember! I have googled, and used the Help file, but all I get is information about clearing the contents etc of a range! This make sense? Thanks. Demon. Insert Name Define Select the name in the list and click Delete. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel {2007} Named Ranges: Renaming, Deleting etc...
In Excel 2007, choose the Formulas ribbon, and then click the "Name Manager"
button in the Defined Name panel. From that dialog, you can delete the name. Note that names have to levels of visibility: Workbook Scope and Worksheet Scope. A Workbook Scope refers to a cell in any sheet and can be used on any sheet, either the same or a different sheet. A Worksheet Scope name is local only to the worksheet. Thus, multiple sheets can each have a name called "SalesTotal" referring to cell A1 on that sheet. Thus, when you use "SalesTotal" on a worksheet, it refers to cell A1 on that sheet. If you use that name on another sheet, you'll get the value of A1 on *that* sheet. While legal, I would recommend against using the same name for a Defined Name and a Worksheet name. It just complicates things and makes debugging and maintenance more difficult. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "DemonTraitor" wrote in message ... I have a range in a worksheet which I named "Prices" using the "Name Box" (The box that shows the Cell reference [A1 etc...]) I am trying to select a different range on another Worksheet and call it "Prices", but whenever I type in the word "Prices", the original "Prices" range is selected on the other worksheet! So, my question is - How do you remove the name from a range, so that the range no longer has a name! I am sure I knew how to do this, but I cannot for the life of me remember! I have googled, and used the Help file, but all I get is information about clearing the contents etc of a range! This make sense? Thanks. Demon. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel {2007} Named Ranges: Renaming, Deleting etc...
Insert Name Define Select the name in the list and click Delete. As the subject line states (I almost missed it too), he is talking about Excel 2007. Your instructions are perfectly correct for versions 2003 and earlier, but not for 2007. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Stephen" <none wrote in message ... "DemonTraitor" wrote in message ... I have a range in a worksheet which I named "Prices" using the "Name Box" (The box that shows the Cell reference [A1 etc...]) I am trying to select a different range on another Worksheet and call it "Prices", but whenever I type in the word "Prices", the original "Prices" range is selected on the other worksheet! So, my question is - How do you remove the name from a range, so that the range no longer has a name! I am sure I knew how to do this, but I cannot for the life of me remember! I have googled, and used the Help file, but all I get is information about clearing the contents etc of a range! This make sense? Thanks. Demon. Insert Name Define Select the name in the list and click Delete. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel {2007} Named Ranges: Renaming, Deleting etc...
GORGEOUS THANKS - was doing my head in!!!!! Thank you beyond compare!
On 27 Nov, 11:35, "Chip Pearson" wrote: In Excel 2007, choose the Formulas ribbon, and then click the "Name Manager" button in the Defined Name panel. From that dialog, you can delete the name. Note that names have to levels of visibility: Workbook Scope and Worksheet Scope. A Workbook Scope refers to a cell in any sheet and can be used on any sheet, either the same or a different sheet. A Worksheet Scope name is local only to the worksheet. Thus, multiple sheets can each have a name called "SalesTotal" referring to cell A1 on that sheet. Thus, when you use "SalesTotal" on a worksheet, it refers to cell A1 on that sheet. If you use that name on another sheet, you'll get the value of A1 on *that* sheet. While legal, I would recommend against using the same name for a Defined Name and a Worksheet name. It just complicates things and makes debugging and maintenance more difficult. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consultingwww.cpearson.com (email on the web site) "DemonTraitor" wrote in message ... I have a range in a worksheet which I named "Prices" using the "Name Box" (The box that shows the Cell reference [A1 etc...]) I am trying to select a different range on another Worksheet and call it "Prices", but whenever I type in the word "Prices", the original "Prices" range is selected on the other worksheet! So, my question is - How do you remove the name from a range, so that the range no longer has a name! I am sure I knew how to do this, but I cannot for the life of me remember! I have googled, and used the Help file, but all I get is information about clearing the contents etc of a range! This make sense? Thanks. Demon.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named ranges in Excel 2007 | Excel Discussion (Misc queries) | |||
problem in deleting the named ranges | Excel Worksheet Functions | |||
Deleting Named Ranges | Excel Worksheet Functions | |||
Excel 2007 Beta-Named Ranges | Excel Discussion (Misc queries) | |||
Deleting many named ranges | Excel Worksheet Functions |