Excel - how do I attach arrows to increase-decrease cell value?

J

Johnphi

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...
 
G

Gord Dibben

Insert a Spin Button from Forms Toolbar or Control Toolbox.

Assuming upgrade means 2007 version.......

Click on Developer Tab and in Controls category Insert>Form 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 Button>Excel Options.

Under Top Options for Working with Excel checkmark Show Developer Tab in
Ribben.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The whole page moves with the up/down arrows, not the cells 1
complicated excel formula may need an algebra wiz 1
Finding asymptote equation and how to draw them in excel 0
Conditional Formating with Icon set - How to change the color 3
how to decrease cell1 value if i increase cell2 value & visaversa 6
excel 07, i don't want circular reference arrows every time I open 1
How do I remove the arrows after showing dependencies 1
how do I set the arrow keys to move only the highlight not the ta 1

Top