Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CommandButton - Created using Forms toolbar | Excel Discussion (Misc queries) | |||
How do I take a toolbar created at home and install it at work? | Excel Discussion (Misc queries) | |||
how do you stop editing the text in a created button | Excel Discussion (Misc queries) | |||
Problem Deleting Check Boxes created from Forms Toolbar | Excel Discussion (Misc queries) | |||
Button not bring up Macro I created | Excel Discussion (Misc queries) |