Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 3 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
2  
Thank you for returning to answer your own question, this solved my problem. –  gosmond Apr 7 '13 at 6:45
add comment

Your Answer

 
discard

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.