| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - how do I attach arrows to increase-decrease cell value?
I just had an excel upgrade and can't find the way to add arrows to a cell.
I old excel the result was to up and down arrows, at the side of the cell, which would allow the user to click up or down to change the cell value... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - how do I attach arrows to increase-decrease cell value?
Insert a Spin Button from Forms Toolbar or Control Toolbox.
Assuming upgrade means 2007 version....... Click on Developer Tab and in Controls category InsertForm Controls. Select the spin button and place it where you want. Right-click and Format Control. Pick a cell to link. If you don't see Developer Tab on Ribben go to ButtonExcel Options. Under Top Options for Working with Excel checkmark Show Developer Tab in Ribben. Gord Dibben MS Excel MVP On Thu, 11 Feb 2010 06:26:01 -0800, Johnphi wrote: I just had an excel upgrade and can't find the way to add arrows to a cell. I old excel the result was to up and down arrows, at the side of the cell, which would allow the user to click up or down to change the cell value... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Chart Trendlines and percentages of increase or decrease | Charts and Charting in Excel | |||
| Mouse click to increase/decrease a cell value? | Excel Discussion (Misc queries) | |||
| create up and down arrows to increase and decrease value in a cell | Excel Worksheet Functions | |||
| Excel formula that calculates percentage of increase or decrease | Excel Worksheet Functions | |||
| How do I set a cell that can increase but never decrease? | Excel Discussion (Misc queries) | |||
Linear Mode
