select the cell
hit F2
highlight the A2 part
F4 - each F4 toggles through the absolute/relative combinations

--
HTH

Bob Phillips

"jobra" wrote in message
...
Hi, is there a programming way to change this:
Cell A10=A2+B2
into this
Cell A10=$a$2+B2
Thanks in advance