As you enter, select cell address with mouse in formula bar and hit F4 key to
toggle through the options.
i.e. =a2 select the a2 and F4 then * a3 select the a3 and F4 then ENTER
will give you =$A$2*$A$3 or whatever you chose by cycling through the options.
Or do the F4 on the entire formula after Entering it.
Gord Dibben MS Excel MVP
On Thu, 27 Sep 2007 10:40:01 -0700, Derek <Derek@>