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?