Have a rather big sheet, and 25 of them that need to be set as absolute
formulas.IS there a way to change all formulas in column 1 to absolute

the formulas looks like this now : =sum(G138/9*12)
need it to be =sum($G$138/9*12)
and some just =sum($G138/9*12)
(the formulas are all like in each column, there are 354 rows in all 25
sheets)
Is it possible to mark the cells you want to change and do it??

PLEASE SAY YES, LOOL, OR THIS WILL BE A ALL NIGHTER
Have tried ctrl+b but did not find any way to do it
--
Just a regular user