Microsoft Office Tutorials and References
In Depth Information
You will find these examples in the Excel Chapter 15 file:
1. On the Review sheet of the Chapter 15
le, you will see the following example,
where the formulas are revealed on the right side.
Create the cell names in column B. Use the names in column A.
2. Apply the names you just created to the formulas in column B.
1. Select A1:B7 and under the Formulas ribbon, click on Create from Selection. On
the Create Names from Selection menu, select Left column. See
gure below. In
Excel 2003 or Mac Excel 2011 use Insert
2. Select A1:B7, click on the drop-down menu next to De
ne Names and use Apply
Names. See the
gures for the procedure and the results.