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 ➡
https://help.libreoffice.org/latest/e...