How to Use Spin Button in Excel

In this lesson you will learn how to create and configure spin button in Excel.

Insert a form

Spin button is one of vba forms in Excel. It can be useful in spreadsheets, formulas and charts.

To insert spin button first go to Ribbon > Developer tab > Insert > Form controls and click Spin button.

Excel Insert Spin Button

Put spin button in your spreadsheet and adjust size. It should look like this:

Excel Spin Button Size

Format the Spin Button

To configure spin button click right button and go to Format control > Control tab.

Excel Spin Button Format Control

Choose Minimum value, Maximum value, Incremental change and link spin button with a cell.

Excel Spin Button Properties

Now you can increase or decrease value in the cell. In this way you can change values of cells which are connected with formulas or charts.