1

First, I'm not sure if this is the right StackExchange site to be posting this on, although I've looked for better ones and couldn't find one. Anyway, my question is this: how can I keep a cell reference in a formula in OOo Sheet constant. What I mean by this is when you write say =B6*A2 into a cell, and drag down, OOo (cleverly) increments all the cell references so you end up with =B7*A3. What I want to do, however, is keep B6 as B6 in each cell, while A3 (and any other cells) can increment to their heart's content. Is this possible in OOo Sheet?

Thanks,

James

Improve this question

1 Answer 1

Reset to default
6

Instead of B6 use $B$6. The $ in front of a row or column indicates that that row / column should remain fixed when copying forumlas.

Have a look at the OOo Formula page (Absolute Referencing section).

(btw - should be on superuser.com)

Improve this answer
2
  • Thank you :-) Sorry for not posting it on SuperUser!
    – Bojangles
    Mar 25, 2011 at 21:37
  • @JamWaffles No problem (on both accounts!) It'll get migrated to SuperUser, there are already 3 votes to do so, 5 are necessary.
    – squillman
    Mar 25, 2011 at 21:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .