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

When I want to multiply a field I can say =J9*K9.

But what if I want this over a selection of rows? I've selected Line 6-25 and for all I want to say =J{THIS_LINE_NUMBER}*K{THIS_LINE_NUMBER}*.

How do I say {THIS_LINE_NUMBER}?

share|improve this question
up vote 2 down vote accepted

Like most spreadsheets, Openoffice will handle this for you if you cut and paste the fomula, or select the region and use "Fill Down". If you have cell e.g. M9 containing =J9*K9, and you paste that into cell M10, it will automatically change that to =J10*K10.

Likewise for horizontal movement.

If you don't want it to do that, you have to put a $ in the relevant place: =$J9 * K$9 will always use column J for the first argument and row 9 for the second argument.

share|improve this answer

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.