7 Performing Calculations on Data
To create a named range from selected cells
On the Formula Bar, click the Name Box.
Type the name you want for the range, and then press
.
To create a named range from a selection including the name
Select the cells you want to name as a range. Be sure either the first or last cell contains the name for the range.
On the Formulas tab, in the Defined Names group, click Create from Selection.
Select the check box for the cell that contains the name you want. Then click OK.
To display the Name Manager
On the Formulas tab, in the Defined Names group, click Name Manager.
To edit a named range
On the Formulas tab, in the Defined ...
Get Microsoft® Office Home and Student 2007 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
