Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
Lets say cell A1 is named "Cheeseburger", what is the easiest way to delete the name so that cell A1 is now simply A1? -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
Also meant to add that you have multiple cell referencing A1 as "Cheeseburger" in their formula and not "A1". -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
i thought we press "DELETE" button in the keyboard to delete any entry .
"mattflow" wrote: Lets say cell A1 is named "Cheeseburger", what is the easiest way to delete the name so that cell A1 is now simply A1? -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
Insert Name Define select "Cheezeburger" in the lower window Delete
Vaya con Dios, Chuck, CABGx3 "mattflow" wrote: Lets say cell A1 is named "Cheeseburger", what is the easiest way to delete the name so that cell A1 is now simply A1? -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
Pressing "DELETE" wont accomplish what i am trying to get done. If i press delete then the cells referencing the cell "Cheeseburger" will still reference "Cheeseburger" and not "A1", however the cell will just have the value 0 (since i deleted its contents). And deleting the name "Cheeseburger" in the cell name box does absolutely nothing. -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
Thanks Chuck, but when I do this then the cells referencing "Cheeseburger" still reference "Cheeseburger", so while deleting the cell in this way does fix one problem, it then leaves me with many name? errors. CLR Wrote: Insert Name Define select "Cheezeburger" in the lower window Delete Vaya con Dios, Chuck, CABGx3 "mattflow" wrote: Lets say cell A1 is named "Cheeseburger", what is the easiest way to delete the name so that cell A1 is now simply A1? -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
BEFORE eliminating the Cheezeburger, do a "Fnd and Replace" to get it out of
the formulas and replace it with A1 Vaya con Dios, Chuck, CABGx3 "mattflow" wrote: Thanks Chuck, but when I do this then the cells referencing "Cheeseburger" still reference "Cheeseburger", so while deleting the cell in this way does fix one problem, it then leaves me with many name? errors. CLR Wrote: Insert Name Define select "Cheezeburger" in the lower window Delete Vaya con Dios, Chuck, CABGx3 "mattflow" wrote: Lets say cell A1 is named "Cheeseburger", what is the easiest way to delete the name so that cell A1 is now simply A1? -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
Thanks Chuck, that seems to be the easiest way to do it. -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
You're welcome, happy to be of help
Vaya con Dios, Chuck, CABGx3 "mattflow" wrote: Thanks Chuck, that seems to be the easiest way to do it. -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=501662 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |