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?