Option buttons return a value in the ‘Cell link’ cell according to the order in which you created them, so the first one will return a value of 1 when clicked, the second one will return the ...

Launch Microsoft Excel and create a Custom List. Go to “ File > Options.” Select the Advanced category from the left pane. Click on the Edit Custom Lists button.

Assign a unique value to each option button (e.g., 1, 2, 3) The selected option button’s value will be stored in the linked cell, allowing you to use it in formulas, conditional formatting, or ...

Load Microsoft Excel. Click the "File" or "Office" button (it varies according to your version of Excel) on the main menu. Select "New" from the list of options, which brings up a dialog box.