View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
O''Malley O''Malley is offline
external usenet poster
 
Posts: 2
Default 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?