Forum Discussion

RMS's avatar
RMS
Occasional Reader
Feb 02, 2026

How to unlink cells in Format Control

I am developing a survey in excel (because the questions are complicated and long and do not format well in e.g. MS Forms) and using option buttons to choose responses. Each question has 6 potential responses. In developer I have inserted a group box, into which I placed 6 option buttons. After formatting the buttons so that they snap to the excel grid I then linked them to a cell to make calculating responses easier. 

On-line advice then suggested that I could copy and paste these to each new question. However, by doing this, I am only able to choose 1 option as they are ALL linked to the same cell.

How do I unlink each group box of 6 option buttons so that I can link each group individually to a different cell for each question? Or - do I have to create a group box and option boxes from scratch for each question set?

I have removed the questions for simplicity of view (note that there are 6 in Q1 and Q2 not visible) and highlighted the linked cell from Q1. As you can see - for Q5 this has given an answer of 26 (the 26th option button) rather than 2 (the 2nd button in Q5) 

 

No RepliesBe the first to reply

Resources