Microsoft Office Tutorials and References
In Depth Information
QUICKLY CREATE MANY RANGE NAMES
Figure 74. Excel 2003 creates i ve named ranges in this selection.
In Excel 2007, with the data set selected, from the Formulas tab, choose Create
from Selection. In the Create Names from Selection dialog, choose Top Row
and click OK (Figure 75).
Figure 75. Excel 2007 creates i ve
named ranges in this selection.