Is there a way to have the absolute value be in your excel formula besides
going back into the formula and putting in the $ signs?

I am looking for a way when I type = then click on a cell - say A1 to have
the formula be =$A$1 rather than=A1 and having to edit the formula

Any suggestions - is there a shortcut key for this maybe?