If you go back to put in the $ try highlighting the range to change and
touching the f4 key.

--
Don Guillett
SalesAid Software

"Dano" wrote in message
...
When I am typing a formula, is there a fast way to designate an absolute
reference? I keep having to go back and put in the "$" sign, which takes a
lot of time. Thanks.