Set full sheet cell formula cells values to absolute

[xlr8urknowledge]

Hey There,
Anyone know how to set all the cell references in all formulas on a sheet to Absolute?
I have a sheet that I needed 750 rows with 6 columns with formulas that were copied and expanded, so they had to only be the cell value in the formulas. I need to lock them down to Absolute ($A$1...), but selecting each reference in each formula, in each cell and hitting F4 will take considerable time. Please let me know if there is a "magic" way to do bulk or full sheet.
Thanks X

 

[Zot]

I guess you need to use macro. Refer here:

Redirecting

 

[bebo021999]

What are the formulas look like? Are they alway need to change cell A1 to $A$1? or A10,B1,...

 

[xlr8urknowledge]

What are the formulas look like? Are they alway need to change cell A1 to $A$1? or A10,B1,...

All various cells from A1 to A750 through 6 columns. A1 - F750.
All cells have formulas that are the same except for the cell reference is unique to the cell it is in via row and column. Cannot paste a "$A1$" formula to A2 cell, but pasted "A1" formula to "A2". Now A2 needs to be $A$2. question is can I do the whole sheet to $A$2 at 1 time or do I need to do each cell formula separately?
Thanks.