Each cell in my worksheet contains long formulas such as this:
if(or(A2=1,B2=1, C2=1,D2=1..... I want to copy the formula to another cell
but I want all cell references to be absolute. How do I convert the relative
addressing to absolute addressing without manually adding $ to each reference?