Add Option Buttons to MS Excel Worksheet
You may want to use Option buttons in MS Excel when there are a small number of options from which to choose. Option buttons are added by using the Forms toolbar.
If the Forms toolbar is not visible, right-click on a toolbar and in the resulting shortcut menu, select Forms.
Follow the steps below to learn how to add these buttons to your worksheet:
- From the Forms toolbar, click and drag the Option Button to place it in your worksheet.
- Select and delete the text in the box.
- While holding down your ALT key, drag the Option Button to the appropriate cell.
- Select the Option Button in edit format and right-click.
- From the resulting shortcut menu, select Format Control.
- Select the Control tab.
- In the Cell link box, type the reference of the linked cell, the name LinkNumber.
Pay attention to the order in which you copy Option Buttons and paste them into the sheet. The linked call, LinkNumber, will return the value of the Option Button according to the order in which it was pasted from the Form toolbar. That means that the first button will return the number 1 to the linked cell. The second button pasted will return the result 2 to the linked cell, etc.
When you add two more Options Buttons to the sheet, both buttons will automatically be updated with the linked reference upon being pasted into the sheet. Therefore you do not need to update these buttons with the reference of the linked cell.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
Free guide: Windows 8 Cheat Sheet: Keyboard Shortcuts. Microsoft Windows has always had some fantastic time-saving keyboard shortcuts designed to make our lives easier. For example: CTRL-X will cut text or objects, and CTRL-V will paste them. (Of course, you can use your mouse to achieve the same thing, but it requires clicking and fumbling through menus, which can be a huge time waster if you cut and paste 50+ times a day). With Windows 8, Microsoft has added many new keyboard shortcuts to their operating system; unfortunately, it's a bit of a learning curve. That's where the Windows 8 keyboard shortcuts cheat sheet comes in! Simply download the guide and reference it when you need to. You'll save a ton of time using your keyboard, rather than reaching for the mouse and flipping through oodles of menus trying to find what you're looking for. Share and enjoy! Click here to download this guide now! Note: this guide is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.