Saturday, December 22, 2012

How to Use Spin Buttons in Excel


1. Use Excel to create your chart or document. Note: Be sure to save your work every few minutes.
2. Open the 'Developer' tab, select 'Controls,' and then 'Form.'
3. Select the 'Insert' option on that tab. You will see this with a little folderlike icon and some tools.
4. Click on your Excel document where you want the spin button to appear. The place where you click is where the upper-left hand corner of the button will appear.
5. Select the 'Properties' option from the 'Developer' tab and 'Controls.'
6. Start setting your options for the spin button. Let's say that you decided on the age of a person. Select a standard age, such as 25. Then select a starting (minimum) age, such as 21. Next, select an ending (maximum) age, such as 100. Then select the increments in which the numbers go up, such as one year at a time, five years, etc. Finally, fill in the spot that asks for cell information.
7. Click to save your changes and then once again click to save your Excel document.

Blogger news