cell names in functions
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
|