Change all cells to Absolute $?$

[j4ymf]

Hello
Is there a way where you can change all the cells to absolute references?

I want to select A1:OO100 and change all the formula to $?$ what is the short cut to do this?
im using a Mac.

Thank you

 

[mole999]

not sure about Mac, F4 cycles it, or maybe ASAP utilities is available for Mac

 

[j4ymf]

Thank you

 

[Biz]

I would use vba code in he weblink below
https://www.ozgrid.com/VBA/formula-ref-change.htm