excel drag constant cell code example

Example: excel keep cell constant

=$B2 //keep constant column
=B$2 //keep constant row
=$B$2 //keep constant cell