# How to Create a Tally Button in Excel: 2 Suitable Methods

### Method 1 – Create a Spin Button in Excel

Step 1: Insert a Spin Button

• You have to enable the Developer tab.
• Go to Developer tab > Insert menu.
• Select the spin button in Form Control.

• Draw a button in the worksheet where you want to locate it.
• The Spin button will be created.

Step 2: Format Spin Control Button

• Right-click on the button to open the options.
• Select the Format Control option.

• Keep remaining in the Control tab.
• The current value is showing the value, which is in the Amount cell at present.
• Assign the minimum value of the amount as \$1000 and maximum as \$30000.
• Specify the increment as \$1000.
• Assign the command cell to link with C7, which contains the amount.
• Press OK.

• See that clicking the up arrow of the spin button increases the amount by \$1000, and clicking the down arrow decreases the amount by the same amount.

### Method 2 – Create a Scroll Bar as a Tally Button

Step 1: Insert Scroll Bar

To the Spin button, you can insert the Scroll bar in Excel.

• Draw a box to place the scroll bar at the position.
• You will draw a box below the interest rate cell as you want to use the scroll bar.

Step 2: Format Scroll Bar

• Rightclick on the scroll bar to open the options and select the Format Controls option.
• Adding interest rate which is in percentage format and in decimal value, but you can’t insert fractional digit in the Format control options.
• Specify the minimum, maximum, and increment change values with 10 multiplications and insert the cell link as D8.
• Insert this formula into cell C8 and convert this cell to percentage format.
`=D8/1000`
• The interest rate minimum is now 1% and increases by 0.5% with each click.

• You have added a scroll bar tally to insert the interest rate.

Add other form control buttons. You can complete the EMI calculator in Excel. With tally buttons, you can easily compare the EMI values in Excel.

## Things to Remember

• In the Format control option, you can’t give any fractional value.
• And the scrolling value will have to be between a minimum of 0 and a maximum of 30000.

## Related Articles

<< Go Back to Tally in Excel | Excel for Statistics | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF