How to lock array of formulas with Absolute value

[Jongo1]

I want to move my table to a different spot but I don't want to go into each individual formula and press F4. Is there away to just select the whole thing and lock it?

Also, another question. If I want to lock a certain part of my formula as absolute and then the other part as a variable based on cells - like below. How do I move I10, J10, K10, M10 to a different section at once without having to individually change each one by either dragging or going into the formula itself.

=(($AO10*I10)+($AP10*J10)+($AQ10*K10)+($AR10*L10)+($AS10*M10))/$AT10

 

[Muhammad_Usman]

I want to move my table to a different spot but I don't want to go into each individual formula and press F4. Is there away to just select the whole thing and lock it?

Also, another question. If I want to lock a certain part of my formula as absolute and then the other part as a variable based on cells - like below. How do I move I10, J10, K10, M10 to a different section at once without having to individually change each one by either dragging or going into the formula itself.

=(($AO10*I10)+($AP10*J10)+($AQ10*K10)+($AR10*L10)+($AS10*M10))/$AT10

While lock your range , keep one thing in mind that when Dollar sign ($) is start then it will lock row not column like $AO10 , and if it dollar sign in middle then it will lock column like I$10. In this situation if i understand you will lock I10 to I$10 to change the column.