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

O

O'Malley

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?
 
O

O''Malley

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

Peo Sjoblom

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

if I select B2 and type


=IF(A>2,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
 
O

O''Malley

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