How to add the Enter key as a button to a formula toolbar created
 

I created a formula toolbar that includes: = + - * / ( ) to help with
entering in formulas using the mouse. How can I add the Enter key as a
button onto this toolbar so I do not have to take my hands off of the mouse
and use the keyboard. The formula bar has a green check mark when entering
in formulas, can I get that green checkmark button onto my toolbar?

How to add the Enter key as a button to a formula toolbar created
 

Can't you just click the mouse in the next cell where you want to go?


--
Regards,

Peo Sjoblom


"O'Malley" wrote in message
...
I created a formula toolbar that includes: = + - * / ( ) to help
with
entering in formulas using the mouse. How can I add the Enter key as a
button onto this toolbar so I do not have to take my hands off of the
mouse
and use the keyboard. The formula bar has a green check mark when
entering
in formulas, can I get that green checkmark button onto my toolbar?

How to add the Enter key as a button to a formula toolbar crea
 

No, it will add that cell to the formula. I know I can click the green check
mark, but I was hoping I could add that same button to my new toolbar to keep
it right next to the other buttons I use.

"Peo Sjoblom" wrote:

Can't you just click the mouse in the next cell where you want to go?


--
Regards,

Peo Sjoblom


"O'Malley" wrote in message
...
I created a formula toolbar that includes: = + - * / ( ) to help
with
entering in formulas using the mouse. How can I add the Enter key as a
button onto this toolbar so I do not have to take my hands off of the
mouse
and use the keyboard. The formula bar has a green check mark when
entering
in formulas, can I get that green checkmark button onto my toolbar?

How to add the Enter key as a button to a formula toolbar crea
 

It doesn't add the cell for me, how are you entering the formulas

if I select B2 and type


=IF(A2,1,2)

then click in B3 it will not add B3 to the formula

if I type

=SUM(D1,E4,D7,D10,E12)

in cell H2 and click in H3 it will not add H3



--
Regards,

Peo Sjoblom



"O''Malley" wrote in message
...
No, it will add that cell to the formula. I know I can click the green
check
mark, but I was hoping I could add that same button to my new toolbar to
keep
it right next to the other buttons I use.

"Peo Sjoblom" wrote:

Can't you just click the mouse in the next cell where you want to go?


--
Regards,

Peo Sjoblom


"O'Malley" wrote in message
...
I created a formula toolbar that includes: = + - * / ( ) to help
with
entering in formulas using the mouse. How can I add the Enter key as a
button onto this toolbar so I do not have to take my hands off of the
mouse
and use the keyboard. The formula bar has a green check mark when
entering
in formulas, can I get that green checkmark button onto my toolbar?

How to add the Enter key as a button to a formula toolbar crea
 

If I use a formula with operators. =A1+(B1*C1) for example. Again, I know I
can click the green check mark on the formula bar, but with using the
operator toolbar, it would be more convenient to have it located there as
well. Thanks for your help.

"Peo Sjoblom" wrote:

It doesn't add the cell for me, how are you entering the formulas

if I select B2 and type


=IF(A2,1,2)

then click in B3 it will not add B3 to the formula

if I type

=SUM(D1,E4,D7,D10,E12)

in cell H2 and click in H3 it will not add H3



--
Regards,

Peo Sjoblom



"O''Malley" wrote in message
...
No, it will add that cell to the formula. I know I can click the green
check
mark, but I was hoping I could add that same button to my new toolbar to
keep
it right next to the other buttons I use.

"Peo Sjoblom" wrote:

Can't you just click the mouse in the next cell where you want to go?


--
Regards,

Peo Sjoblom


"O'Malley" wrote in message
...
I created a formula toolbar that includes: = + - * / ( ) to help
with
entering in formulas using the mouse. How can I add the Enter key as a
button onto this toolbar so I do not have to take my hands off of the
mouse
and use the keyboard. The formula bar has a green check mark when
entering
in formulas, can I get that green checkmark button onto my toolbar?