how to lock excel from dragging?

[babaso_tawase]

how to lock excel from dragging in unlocked cell in locked excel sheet?

A	B

<tbody>
</tbody>

In Column A is unlocked and in B locked Cell, if dragged unlocked cells then formula in Column B changes (as formula depends on cell value in column A) to no of cells that dragged.
I want lock dragging function in excel , is it possible?
Thanks.

 

[babaso_tawase]

Thanks for reply..