Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am currently calculating percentages in LibreOffice Calc using the function =PART/TOTAL where PART and TOTAL are cell coordinates of a same column.

Dragging-down the formula won't do, because the coordinate of the TOTAL cell will change along with the PART's.

Ideally, I want to process this quickly, in a way that the coordinates of the PART changes while the TOTAL's would remain the same.

How can I do that? Is there a function for this?

share|improve this question
up vote 3 down vote accepted

Modify the formula from, say, =A1/A2 to =A1/$A$2 before copying it, so that the denominator will not change.

share|improve this answer
Thanks, you save me hours :) – Benjamin Aug 12 '11 at 13:19
Also, you can just fix the column using $A2 or just fix the row with A$2. This is useful when copying between different columns/rows (depending how your data is laid out) – nico Aug 12 '11 at 13:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.