shortcuts to formulas

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.
 
L

Luke M

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.
 
Y

Yogisnort

Thanks, Luke. I knew I could do that, but I hoped I could get to my favorite
formula even quicker.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scroll does not show preview 0
Sumif apllying to all sheets in workbook 2
Depedent Dropdown and INDIRECT($P$8) with a twist 4
sum of multiple rows 2
Drop down list from index/match formula 1
Advanced Drop-down Menu 2
If Function and Vlookups 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top