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?**