Super User is a question and answer site for computer enthusiasts and power users. 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'd like to create a simple Calc sheet, where column A contains the days, B contains how many hours of work i had done and C the price for that day. The price is simply a multiplication of hours (B col.) and a predefined price. But the price per hour may change, so I'd like this to be in a cell too, and the daily price formula for C3 could be =B3*A30 where A30 is the price per hour. But if i copy the C3 cell to C4, C5, ... the A30 cell reference moves down too, to A31, A32..., just like the B3 moves down to B4, B5...

How can I make a cell reference fixed, while the other relative when copy-pasting cell in Libreoffice Calc?

share|improve this question
up vote 6 down vote accepted

I found the solution: the formula in column C should be like this:

(C3 cell) =B3*$A$30

This way, on copy-paste only the B3 reference is rewritten, the A30 is left unchanged. The $A$30 syntax can be achieved with Shift+F4 too.

share|improve this answer
Thank you for returning to answer your own question, this solved my problem. – gosmond Apr 7 '13 at 6:45
Also using Shift+F4 multiple times will cycle through the variations of absolute rows&cols OR rows OR cols. I was unable to paste cell to other cells in opencalc, can now. – jm_____ Sep 11 '14 at 15:48

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.