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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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