How to Lock Cell in Formula (Keep Cell Constant) | LibreOffice Calc

LibreOffice Calc uses relative references by default, but if you want to lock one or all of the cells in your formula, you can change it to use absolute reference(s).
For more information about using addresses & references, absolute & relative, the official help page is here ➡
help.libreoffice.org/latest/e...

[@yuiyuiyuiyui8800]

Thank you, thank you, thank you.....

[@ecospline]

I wondering if this behaviour can be incorporated to sheets as copying sheets with dependencies to other sheets acts in the same way (relative reference)