Follow

LibreOffice calc - neat copy/paste trick 

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.

Web 0 0 0
Sign in to participate in the conversation
Octodon

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!