Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

For example I made check box in A1 with "=$B$1" So now, when I click it the "TRUE", "FALSE" text appears depending if check box is checked or not.

The problem starts when I want to duplicate those two to more rows. Now every check box makes the B1 text to change, not the one it represents as in check box A1 should change B1 text, check box in cell A2 should change B2 text and so on, but now all check boxes change the same B1 text.

Is there any workaround?

share|improve this question
How did you create the check box and how did you control it? If you copied the check box, it is exactly that; a copy with the same properties. A little more information will help us help you. – CharlieRB Aug 31 '12 at 19:25

The problem may be partly due to the absolute position you are using when defining your checkboxes. The dollar sign in the formula means that when the formula is moved to other cells, the "dollared" value will not change relative to the new location. It's absolute.

Define the checkbox in A1 as "=$B1". Now when you duplicate to A2, the formula there should become "=$B2".

share|improve this answer

Your Answer


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.