Can I change the options available in the “Function” drop down menu? Right now it is: SUM, AVERAGE, MIN, MAX, COUNT. I would like to add PRODUCT so I don’t have to use the Wizard every time.
AFAIK you can’t customise the formula bar.
You don’t need to use the Wizard; just typing =prod and then pressing Enter when you see the tooltip suggesting PRODUCT, will insert the function, with the cursor already between the parentheses.
That is, if you have Tools > AutoInput ticked, else just type =product( enter your ranges ) .
1 Like