login about faq

Beatrice writes:

I have a question, I know how to do a data validation drop down but I need the one list with two buttons in the same cell and a range of years. Do you know how to do this?

I work for the school district and they need a particular calendar. They have a cell where you can list the year but it list whole number with a range of 1999 to 2999 and has two buttons.... one to go up in years and one to go lower... Hope this makes sense

asked Oct 22 '11 at 13:45

grooveDexter's gravatar image


Sure do!

This function you are describing is called a "Spin Button" in excel. There are also two-types of Spin Buttons: Form, or ActiveX.

A Form Spin Button is easier to use, but an Active X can be customized more. Here's how to add them:

1: First, enable the developer Ribbon in Microsoft Excel.detailed instructions here
2: On the developer tab,click Insert > Spin Button (form control).

alt text

3: Click on the location in the document that you want the up/down buttons to appear. They are not locked into cells so you can move and resize them freely.

alt text

4: Make sure the spin button is selected, and then click Properties on the ribbon.

alt text

5: Fill out the values as needed. The cell link is the cell in the spreadsheet they will show up in.

alt text

Hope this helps!


answered Oct 22 '11 at 19:24

grooveDexter's gravatar image


edited Jul 02 '15 at 11:15

Steve's gravatar image



This is EXACTLY what I needed. You're my new hero. Thank you sooo much.

(Oct 22 '11 at 22:42) beeanalystloveexcel beeanalystloveexcel's gravatar image

Great solution!

(Nov 01 '11 at 15:52) Steve Steve's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:
    [text](http://url.com/ "title")
  • image:
    ![alt text](/path/img.jpg "title")
  • numbered list:
    1. Foo
    2. Bar
  • Code:
    • Within a paragraph:
      surround code with grave accents (backticks)
    • Code snippet:
      Select the text and use the button on the icon of zeros and ones
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: Oct 22 '11 at 13:45

Seen: 4,725 times

Last updated: Jul 02 '15 at 11:15

groovyAnswers © 2007 - 2011 All Rights Reserved | Privacy | Contact