how to add "create formula" into the right click on mouse

Question

Level 1

8 points

how to add "create formula" into the right click on mouse

I work in Numbers quite a lot and when calculating numbers, I often have to insert "create formula" to get the totals from certain cells. It would be much easier to have that option (create formula) in my right-click mouse button.

It's a pain in the neck to always go up to the bar and click on the formula then click scroll down on "create".....

Is there any shortcut?

Or is it possible to adjust my options for the mouse right-click button, so I would have that "create formula" button?

Thank you much,

Yana

Posted on Apr 14, 2020 8:23 AM

Reply

Answer 1

Top-ranking reply

Wayne Contello

Level 7

26,583 points

Apr 14, 2020 9:08 AM in response to Yanaran

to enter a formula, you can select the destination cell, then type the equal sign then enter the formula. you can also, in some cases, select a range of cell, then drag a tag from the quick stats in the bottom of the window:

select a range:

Then drag the tag from the bottom of the window.

you can change the quick tags by selecting a range, then opening the sprocket on the right of the bottom of the window:

Reply

Answer 2

Yanaran Author

Level 1

8 points

Apr 14, 2020 10:00 AM in response to Wayne Contello

Oh Wayne, thank you! that is very helpful! I didn't know that just entering the equal sign into the destination cell will do that trick.

Thank you so much!

Reply

how to add "create formula" into the right click on mouse

Similar questions