how do we establish different groups of radio button in excel

[sss]

in my worksheet of one row i have five radio button while in another row 2
radio button ,how do i bifurcate between two rows of radio button, i..e
because excel worksheet is considering all radio button in whole page as one
group. suggestion please....

 

[Joel]

You need to put a Group box around the different groups of buttons

View Menu - Toolbars - Forms

Add two Group boxs to the worksheet.

 

[Dave Peterson]

If you used optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you used optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.