formula
 

how do i make each cell a formula. ie:=10 so when i go to change it i can
just dble click on the cell and +/- a qty?

formula
 

Try using a spinner.
On the forms toolbar (if it is not visible, go to view-- Toolbars--
Forms), click the spinner button. Draw a square in your cell and the spinner
will appear. Right click on the spinner and click format control. On the
control tab, set the Cell Link to your cell. You can also set minimum and
maximum values.

- Search

"jkk" wrote:

how do i make each cell a formula. ie:=10 so when i go to change it i can
just dble click on the cell and +/- a qty?

formula
 

thank you, it did not work though.. what does a spinner do? what i need to do
is make every cell =10 instead of just 10 in a cell. i am using it for a
retail plan. So then when i go to add or cubtract from taht column say to
increase or decrease sales i can just hit f2 then +what i want to increase it
by
help!!
"Search33" wrote:

Try using a spinner.
On the forms toolbar (if it is not visible, go to view-- Toolbars--
Forms), click the spinner button. Draw a square in your cell and the spinner
will appear. Right click on the spinner and click format control. On the
control tab, set the Cell Link to your cell. You can also set minimum and
maximum values.

- Search

"jkk" wrote:

how do i make each cell a formula. ie:=10 so when i go to change it i can
just dble click on the cell and +/- a qty?

formula
 

enter the formula in one cell =10
rigt click <copy
select an area where you want the other cells to have the same
right click<paste
--
Greetings from New Zealand
Bill K

"jkk" wrote in message
...
how do i make each cell a formula. ie:=10 so when i go to change it i can
just dble click on the cell and +/- a qty?

formula
 

Sounds like you are looking for an accumulator cell.

Easy to do but fraught with danger.

Maybe better to enter a formula like =10 + D1

Then in D1 you can enter any number you want and have the cell update.


Gord Dibben Excel MVP

On Thu, 1 Dec 2005 11:28:03 -0800, jkk wrote:

thank you, it did not work though.. what does a spinner do? what i need to do
is make every cell =10 instead of just 10 in a cell. i am using it for a
retail plan. So then when i go to add or cubtract from taht column say to
increase or decrease sales i can just hit f2 then +what i want to increase it
by
help!!
"Search33" wrote:

Try using a spinner.
On the forms toolbar (if it is not visible, go to view-- Toolbars--
Forms), click the spinner button. Draw a square in your cell and the spinner
will appear. Right click on the spinner and click format control. On the
control tab, set the Cell Link to your cell. You can also set minimum and
maximum values.

- Search

"jkk" wrote:

how do i make each cell a formula. ie:=10 so when i go to change it i can
just dble click on the cell and +/- a qty?