Add Spin Button to a Worksheet│Fake Scroll Button in Excel for Dashboard in HINDI│Spinner in Excel

Learn how to use a spin button (also called a spinner) form of control in Excel to aid in data entry.
How to use the form's controls on a worksheet in Excel
Using a spin button, a user can click the button to increase or decrease a value in a worksheet cell.
You can use a spin button to quickly enter or change a range of values in Excel.
This video explains how to access the Developer tab, then, how to add the spin button form control and, finally, how to set up the control. It also explains how to scale the value that the control provides so it can provide percentages and very large or very small values. This feature is in Excel 97, 2000, 2002, Excel 2007, Excel 2010 and Excel 2013.
Spin button:-
Makes it easier to increase or decrease a value, such as a number increment, time, or date. To increase the value, click the up arrow; to decrease the value, click the down arrow. A user can also type a text value directly in the associated cell or text box. Use a spin button, for example, to make it easier to enter a month, day, year number, or to increase a volume level.
Note:-
Before you add controls to your worksheet, you have to enable the Developer tab. For more information, see Show the Developer tab.
Make a Spin Button more useful
You can use a Spin Button like this to make it easy for a user to enter a value into a worksheet by clicking a button rather than typing a value. However, you might be wondering what you can do when the values they are to enter are not whole numbers between 0 and 30,000?
How Scroll Bars work
A ScrollBar works in a similar way to the Spin Button except that with a ScrollBar you can set a Page Change value which is the change in value when you click on the ScrollBar either side of its moving marker. The Incremental Change value is applied when you click on the arrows at either end of the ScrollBar. With a ScrollBar you must, of course, set a Cell Link for the value to be placed in. If you want to scale the value, you'll need to use a second cell with a formula in it that will scale the value that the Scroll Bar gives you appropriately for the end result that you need.
Important Videos Link:
1) How to Make own Customize software in MS-Excel│एक्सेल में बनाये खुद का सॉफ्टवेयर
• Make own Software by C...
2) Create a Data Entry Form in MS-Excel without VBA│एक्सेल में बनाये डाटा एंट्री फॉर्म
• Create a Data Entry Fo...
3) How To Convert Numbers into Words in Excel│नंबरों को शब्दों में कनवर्ट कैसे करें
• How To Convert Numbers...
4) How to insert a checkbox in Excel- HINDI│Create an interactive checklist or To-Do List
• How to insert a checkb...
ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u