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