Where is spinner in excel 2007




















Helen Bradley explains how to add interactive elements to an Excel worksheet using scroll bars and spin buttons. Whenever your user has a discrete number of choices to make for inputting data into an Excel worksheet you can save time by automating how they enter this data. You can do this in a number of ways and one of them is to use a spin button or a scroll bar to do the work. Today, I'll introduce you to using spin buttons and scroll bars and show you an way to add an interactive element to an Excel chart with a spin button.

In Excel and Excel , the spin buttons and scroll bars are accessible from the Developer tab. It's vital that you select those in the Form Controls group not the ActiveX Controls as they work very differently and it's the Form Controls that we are using. Drag a Spin Button onto your worksheet and drag a Scroll Bar onto your worksheet too.

Notice that you can drag your scrollbars so they are oriented either vertically or horizontally. To move or resize a control, right click it to select it and then size or move as required. To see how these work, right click the Spin Button and choose Format Control. In the Control tab are your options for configuring the Spin Button.

Essentially what the Spin Button does is to place a value in a cell for you. As the user clicks on the spinner, the value of the linked cell changes. For example, the following worksheet can be used to examine how changes in three variable inputs price, unit cost, and fixed cost affect profit. To set up the formulas for the worksheet, follow these steps:.

Your manager just learned that increases in material costs have raised the unit cost to. However, even with this drop in demand, profit goes up significantly, which may warrant the price increase.

Check out the Microsoft Excel archive and catch up on other Excel tips. You should upgrade or use an alternative browser. How do I insert a spinner spin box in Excel ? Thread starter innov8ive Start date Nov 28, Can anyone guide me to this little gem or is it lost and gone forever? Niek Otten. Post reply. Ask a Question Want to reply to this thread or ask your own question?

Ask a Question. Similar Threads How do I change the size of check box in forms control? In the Minimum value box, enter the lowest value that a user can specify by clicking the bottom arrow in the spin button. In the Maximum value box, enter the highest value that a user can specify by clicking the top arrow in the spin button. In the Incremental change box, enter the amount that the value increases or decreases when the arrows are clicked.

In the Cell link box, enter a cell reference that contains the current position of the spin button. Use this value in a formula to respond to value of the cell specified in the Cell link box that corresponds to the current position of the spin button. For example, you create a spin button for setting the current age of an employee with the following properties:. With these settings, the user can click the spin button to enter an age that falls within a minimum and maximum age range.

The median age of the employees is 35, and therefore 35 is a good choice to set as the starting value. The following formula in cell D1 determines the length of employment that is based on the current age value in the cell that is linked to the spin button and the employee's age at hire date — the value in B1 retrieved from another data source.

The formula then computes a holiday bonus percentage that is based on years of service:. Note: Clicking the top arrow after the minimum value has been reached or clicking the bottom arrow after the maximum value has been reached has no effect on the value returned.

The spin button remains at either the minimum or maximum value and does not cycle through the range of allowed values. On the Developer tab, in the Controls group, turn on Design Mode.

Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical.



0コメント

  • 1000 / 1000