View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 390
Default 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