Naming Groups of Data To name a range of cells
Select the cells to be included in the range.
Click in the Name box.
Type the name of the range, and press .
Naming Groups of Data To name a range of cells using adjacent cell labels
Ensure that the desired name for the cell range is in the topmost or leftmost cell of the range.
Select the cells to be part of the range.
On the Insert menu, point to Name and then click Create.
Select the check box indicating the location of the cell with the name for the range, and then click OK.
Finding and Correcting Errors in Calculations To write a formula
Click the cell into which ...