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