First, enable the Developer ribbon.

On the Developer ribbon, click Insert » Spin Button.

Next, click the cell where you want the spin button to appear. Then select the Spin Button. On the Developer ribbon, click Properties.

An options box appears. Click the control tab. Enter values if you need to. The cell link value will be the cell in your spreadsheet that the spin button applies to.

Comment Name * Email *

Δ  Save my name and email and send me emails as new comments are made to this post.

Add Up Down Buttons to Spreadsheets in Excel - 50Add Up Down Buttons to Spreadsheets in Excel - 9Add Up Down Buttons to Spreadsheets in Excel - 55Add Up Down Buttons to Spreadsheets in Excel - 70Add Up Down Buttons to Spreadsheets in Excel - 74Add Up Down Buttons to Spreadsheets in Excel - 47Add Up Down Buttons to Spreadsheets in Excel - 64Add Up Down Buttons to Spreadsheets in Excel - 92