Yeah. The UI could have a lock icon to set, eg B1 should stay fixed and then only A1 would change.

It supports this. If you type # before a number, like #5, it's made constant.