Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there,
cell names are great to identify the cells, but when used in a formula, I can not drag them like normal cell references (ie: A1), they seem to be more like th efixed type (ie $A$1), but I can not unlock those (F4 key does not hold for these references), does anyone know the solution for this? Obviously, I can select th ecell name in the formula, replace it with a normal reference and drag this, but I think it is quite inconvenient... Besides, after this, the formula keeps refering to a cell reference, not to a cell name. Thanks in advance, Max |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF functions and Names Ranges | Excel Discussion (Misc queries) | |||
working with names and functions | Excel Worksheet Functions | |||
Excel functions names should be in English for all Localized versi | Excel Worksheet Functions | |||
Tracking worksheet names in functions | Excel Worksheet Functions | |||
are variable table-array names in functions possible? | Excel Discussion (Misc queries) |