use a constant cell in excel formula code example
Example: excel keep cell constant
=$B2 //keep constant column
=B$2 //keep constant row
=$B$2 //keep constant cell
=$B2 //keep constant column
=B$2 //keep constant row
=$B$2 //keep constant cell