After you finish entering the formula, you can select the *entire* formula
in the formula bar, and then hit <F4, and you'll change the *entire*
formula to absolute with just that *one* hit of <F4.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Mike R" wrote in message
...
You can use f4 and it will allow you to toggle through all aspects of
"absolute" for the selected cell.

Mike Rogers

"JMATHES" wrote:

If you were to type a formula in Cell A1 as follows:
=A2*A3

How do you automatically make this formula a relative formula (meaning
add
the $ before and after column and row so it reads $A$2*$A$3) without
having
to manually go into the cell and manually type the "$" sign each time?

Is there a way to tell the sheet to make all formulas relative?