Using recently used functions
Digging through all the different function library menus can be cumbersome, so Excel tries to make your life easier by creating a special Recently Used list that contains (what else?) a list of the functions you've used most often. From this menu, you can just see a list of your favorite functions and ignore the other hundred functions that you may never need in a million years.
To use the list of recently used functions, follow these steps:
- Click the cell where you want to store a function.
- Click the Formulas tab.
- Click the Recently Used icon in the Function Library group. A pull-down menu appears.
- Choose a function.