Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unnaming cells already named
I was wondering if someone knows how to "unname" (or delete the name) a range
of cells I gave a name (1st mistake) and then saved it ( 2nd mistake). Thanks for helping. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unnaming cells already named
hi
on the menu bar.... Insertnamedefine. high light the roque name, click delete button, click ok. done regards FSt1 "Learning Excel" wrote: I was wondering if someone knows how to "unname" (or delete the name) a range of cells I gave a name (1st mistake) and then saved it ( 2nd mistake). Thanks for helping. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unnaming cells already named
Thanks FST1, exactly my solution.
-- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. "FSt1" wrote: hi on the menu bar.... Insertnamedefine. high light the roque name, click delete button, click ok. done regards FSt1 "Learning Excel" wrote: I was wondering if someone knows how to "unname" (or delete the name) a range of cells I gave a name (1st mistake) and then saved it ( 2nd mistake). Thanks for helping. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unnaming cells already named
hi
you're welcome. glad to help Regards FSt1 "Learning Excel" wrote: Thanks FST1, exactly my solution. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. "FSt1" wrote: hi on the menu bar.... Insertnamedefine. high light the roque name, click delete button, click ok. done regards FSt1 "Learning Excel" wrote: I was wondering if someone knows how to "unname" (or delete the name) a range of cells I gave a name (1st mistake) and then saved it ( 2nd mistake). Thanks for helping. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unnaming cells already named
You can copy and paste a blank cell.
"FSt1" wrote in message ... hi on the menu bar.... Insertnamedefine. high light the roque name, click delete button, click ok. done regards FSt1 "Learning Excel" wrote: I was wondering if someone knows how to "unname" (or delete the name) a range of cells I gave a name (1st mistake) and then saved it ( 2nd mistake). Thanks for helping. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unnaming cells already named
That only clears the contents of the named cell. The cell retains its name.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob" wrote in message ... You can copy and paste a blank cell. "FSt1" wrote in message ... hi on the menu bar.... Insertnamedefine. high light the roque name, click delete button, click ok. done regards FSt1 "Learning Excel" wrote: I was wondering if someone knows how to "unname" (or delete the name) a range of cells I gave a name (1st mistake) and then saved it ( 2nd mistake). Thanks for helping. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unnaming cells already named
Yep, you're right.
"Jon Peltier" wrote in message ... That only clears the contents of the named cell. The cell retains its name. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob" wrote in message ... You can copy and paste a blank cell. "FSt1" wrote in message ... hi on the menu bar.... Insertnamedefine. high light the roque name, click delete button, click ok. done regards FSt1 "Learning Excel" wrote: I was wondering if someone knows how to "unname" (or delete the name) a range of cells I gave a name (1st mistake) and then saved it ( 2nd mistake). Thanks for helping. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup & named cells | Excel Worksheet Functions | |||
Lookup & named cells | Excel Worksheet Functions | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
same Named cells in different sheet | Excel Discussion (Misc queries) |