Microsoft Office Tutorials and References
In Depth Information
Mac Excel 2011
FIGURE 15.10 Formulas without Names
FIGURE 15.11 Apply Names Menu
We have to take two steps as we did before. First, we have to select the two
columns, B and C, and use Insert
Create. The same procedure you see in
Figure 15.8. The cell will be named. However, the formulas will not have the names
as part of them. In order to APPLY the names to the formulas, you have to select the
two columns again, B and C, and use Insert
>Apply. See Figure 15.11 for
the procedure.
See the results in Figure 15.12. Now the model makes much more sense.
Mac Excel 2011
With Excel 2011 the procedure is similar to Excel 2007.
Search JabSto ::

Custom Search