Note that is using the absolute reference works for you, you can cycle
through the absolute options by pressing the F4 key while editing the
formula.