Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting Name from Name Box
Go to Insert = Name = Define
Pick the name from the list and in 'Refers to' change the call reference from e.g. =Sheet1!$A$1:$A$5 to =INDIRECT("Sheet1!$A$1:$A$5") This will prevent the name being shown in the name box. Cheers, Joerg Mochikun "Workbook" wrote in message ... Is it possible to delete a name(s) from the name box once you have given a cell or group of cells a specific name? and if so could you tell me how I can do so? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting a row | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
Deleting name all at once | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel |