asked Oct 22 '11 at 13:45
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
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.
4: Make sure the spin button is selected, and then click Properties on the ribbon.
5: Fill out the values as needed. The cell link is the cell in the spreadsheet they will show up in.
Hope this helps!