Microsoft Office Tutorials and References
In Depth Information
for the SUM
5. Press Enter.
Excel automatically sums all the cell references.
The AutoSum icon also appears on the Home tab in the Editing group.
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 see just 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:
1. Click the cell where you want to store a function.
2. Click the Formulas tab.
3. Click the Recently Used icon in the Function Library group.
A pull-down menu appears, as shown in Figure 9-5.
4. Choose a function.
The more functions you use, the more your list will vary from what you see in