Excel Trick : How to create Radio buttons in MS Excel || Excel Tips || dptutorials

In this tutorial, let us learn How to create Radio buttons in MS Excel
Options button or Radio button can be used in Excel to choose a particular option from some multiple options.
Let us consider an example that you are creating a survey and you require to create questions with 4 options to choose from.
You have to get the answer to the option that has been selected like this.
To create option buttons, first, you need to go to the Developer tab
To add developer tab like this to the menu bar, you need to right-click ribbon and select customize the ribbon option and then under Choose commands from the drop-down menu, select all commands,
click on Developer command and click on add button to add that control into the main tabs to the right side and click ok.
Once the developer tab is added to your menu bar, go to Developer tab in the menu bar, under Controls group, click on Insert and from the “Form Control” click on the option button and draw a rectangle on the sheet to insert the options button.
Copy the options button and paste it for 3 more times, so that we have the 4 choices now.
Change the name of every option button and name it as per requirement based on the question.
Let us put the question as "Which State you belong to?"
now put the options as "Maharashtra", "Andhra Pradesh", "Kerala", "Telangana"
Select any option button and right click and select format control
Format Object dialog box will open up, under control, In the cell link, select any cell, say I2 in the sheet and click OK.
By doing this, Whenever you select any option, the linked cell number will get change according to the selection.
Enter the formula in cell B8, to check which option the user has selected.
=IF(I2=1,"Maharashtra",IF(I2=2,"Andhra Pradesh",IF(I2=3,"Kerala","Telangana")))
Press Enter
Now, whatever option you will select, it will show as an answer in this cell.
You can add more questions and format the page accordingly, to design surveys, dashboards, etc.
So friends, in this way you can use the radio buttons in the MS Excel.
For Personalized detail learning, write to [e-mail]
If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.
***********************************************
★ My Online Tutorials ► www.dptutorial...
LEARNING RESOURCES I Recommend: www.dptutorial...
Subscribe for more Awesome Tutorials: goo.gl/NyAtg2
Support the Channel via shopping: ift.tt/2jH38PR
Tools that I use for Vlogging:
• Laptop: amzn.to/2E5U3MO
• Canon 200D Camera: amzn.to/2HglDYA
• Benro Tripod: amzn.to/2ExRvYj
• Blue yeti microphone: amzn.to/2VwZyPn
• Collar Microphone: amzn.to/2VyOdcM
• Bluedio Headset: amzn.to/2W3xUZX
• Screen recorder: techsmith.pxf....
• Boom Arm Stand: amzn.to/2VCQNi7
• Zoom H1 Audio Recorder: amzn.to/2VDumsT
• Harison Softbox Studio Lights: amzn.to/2LY7x3u
• Chroma Key Green Screen: amzn.to/2ExTr31
• Background Support Stand: amzn.to/2McqnEv
• Acoustic Foam Background: amzn.to/2EoQ1zj
• USB RGB LED Strip: amzn.to/2VItKm4
• Wireless Mouse: amzn.to/2E23cpN
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
***********************************************
You Can Connect with Me at
TH-cam: / dptutorials
G+: ift.tt/2kAOpa6
Twitter: / dptutorials15
Facebook: ift.tt/2kfRnDi
BlogSpot: ift.tt/2kB14dh
Follow:
www.dptutorials.com
www.askplanner.blogspot.com
Tags: -
excel formulas in English, excel in English, excel tutorial in English,ms excel in English,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in Hindi, excel formulas and functions in Hindi, excel tricks, excel in Hindi, excel shortcut keys, excel vlookup, excel formulas in Hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, Excel Sum Formula, Sum Formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training

[@krmotionexcel]

Goooooooooooooooooood idea........
I have 60 documents list Country wise , i have filter only party wise show documents , like party name " Global AB, USA " only show this party documents only........

[@dptutorials]

Hi, Please write it down to [e-mail], so that I can understand the question in detail and try to resolve the difficulty.