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
Conditional Formating with Icon set - How to change the color 3
Excel will not move from cell to cell with arrows, only scrolls 1
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 put a scroll bar within a cell to change its contents? 1
Mouse click to increase/decrease a cell value? 7
How do I move to other cells in spreadsheet using up down arrow? 2

Top