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 in each cell, while
A3 (and any other cells) can increment to their heart's content. Is this possible in OOo Sheet?