Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

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?



share|improve this question

migrated from Mar 26 '11 at 0:06

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

up vote 5 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

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

You must log in to answer this question.

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