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

How can I get LibreOffice Calc to automatically fill in formulas from the current row into the next row?

I have a spreadsheet for keeping track of my personal finances and I'd like to just press enter or another button on the current row to jump to the next (new and empty) row and have the formulas from the previous row inserted into this row.

share|improve this question
Have you tried drag and drop, that is by placing the mouse point on the fill handle and dragging it to the rows that you want to be filled with formulas? – Peachy Oct 28 '12 at 11:59
@msPeachy Yes, I'm aware of that, but that's not what I want. – Joe Doe Oct 28 '12 at 12:01

Your Answer


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

Browse other questions tagged or ask your own question.