How-To

MS Excel: Add Up/Down Buttons to Spreadsheets

Developer Tab

Here’s how to add up and down buttons to your Excel spreadsheets.

First enable the developer ribbon.

Developer Tab

On the developer ribbon, click Insert >> Spin Button.

image

Next click the cell where you want the spin button to appear.
image

Next select the Spin Button. On the developer ribbon, click Properties.

image

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.

image


Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

 

To Top

Free Learning

Don't miss a single tip, how to or tech news update. Subscribe to my free newsletter and receive updates, right to your inbox.

You have Successfully Subscribed!