こういう事じゃないの
https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative/ja
https://help.libreoffice.org/Calc/Recognizing_Names_as_Addressing/ja