Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

migrated from serverfault.com Mar 26 '11 at 0:06

This question came from our site for professional system and network administrators.

1 Answer 1

up vote 4 down vote accepted

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)

share|improve this answer
    
Thank you :-) Sorry for not posting it on SuperUser! –  Bojangles Mar 25 '11 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 '11 at 21:39

Your Answer

 
discard

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.