shortcuts to formulas

  • Thread starter Thread starter Yogisnort
  • Start date Start date
Y

Yogisnort

Can you create a button for the tool bar for frequently used formulas like IF
or SUMIF? The drop-down menu from the SUM formula icon gives me 5 choices, of
which I rarely, if ever, use four. I would like to replace these with
formulas of my own choosing or add a button to the tool bar for the formulas
I use several times a day every day.
 
Not a direct answer to your question, but if you click the "fx" next to the
equation editor toolbar, it brings up a list of recently used formulas.

The 5 choices listed under AutoSum only need an array defined, so XL doesn't
need too much guidance. IF and SUMIF require criteria, so it definitely
requires some user input.
 
Thanks, Luke. I knew I could do that, but I hoped I could get to my favorite
formula even quicker.
 
Back
Top