Microsoft Office Tutorials and References
In Depth Information
Use Named Areas
What You Press
What You Get
F9
Calculates formulas that have changed since the last
calculation, in all open workbooks
Shift + F9
Calculates formulas that have changed since the last
calculation, just in the active worksheet
Ctrl + Alt + F9
Calculates all formulas in all open workbooks,
regardless of when they were last calculated
Figure 18-4:
Setting the
calculation
method.
Use Named Areas
Heck, maybe it’s just me, but I think it is easier to remember a word such
as Customers or Inventory or December than it is to remember B14:E26 or
AF220:AR680. So I create names for the ranges I know I’ll reference in my
formulas and functions.
Naming areas is easy to do, and in fact, you can do it a few ways. The first is
to use the New Name dialog box. You can get to this by clicking the Define
Name button on the Formulas tab on the Ribbon. In the dialog box, you set a
range, give it a name, and press the OK button. See this in Figure 18-5.
Figure 18-5:
Defining a
named area.
Search JabSto ::




Custom Search