Hi, I have a scenario here but I am not sure how to do it.
I have a spreadsheet here. For example:
The cell 1 value is =$A1$b2 and the cell value for other
cells are other misc formulas similar to cell 1 without
the dollar sign..say example: =B6O5
How can I copy the $ referral sign and paste it to other
cells and made everything into =$X$Y format without
having to manually add it on every cell?

Thanks

Billy