Say your formula is `=C4*G2`, and you want to copy that to other rows, but only have C4 adjust to C5, C6 etc. while keeping G2 constant. You can do that by changing the formula to `=C4*G$2` (insert dollar sign), that way `G$2` will not be shifted in paste operations. #LibreOffice